Excel / VBA Consultancy

Free Training Videos

Free Spreadsheets

Excel / VBA Jobs

Navigation

New Excel Experts

milagroscanterbury63
shanelsosa9583420
tiffinybeaver135352

Current Excel / VBA Jobs

More jobs

Updating drop down based on previous cell

Submitted by harish on 7 December, 2012 - 09:22

Question and Answer

Hi all,

I have struck with updating drop down based on previous cell value.

Here is my problem..
I have 2 sheets.. 1st sheet looks as..

Locale OS Version Size
US win7 10 30
US mac 10.7 10.1.4 45
Japan win7 10 78
Japan mac 10.7 10.1.4 90
Japan mac 10.8 11 80

In the second sheet the same columns..

If we give Locale as US then all available OS should be updated in a drop down in OS column and if we select an OS from that list..all available versions for that particular Locale and OS should be updated as a dropdown in version column..there if i select a version then size should be auto populated based on previous three cell values..

Its an emergency..pls help..thanks in advance..

Login or register to post comments
ShareThis
2771 reads

how to see the response in

Submitted by harish on 7 December, 2012 - 18:08.

how to see the response in separate thread..I didn't get that..

1.Go to Forums -> Question

Submitted by AndyLitch on 7 December, 2012 - 19:59.

1.Go to Forums -> Question and Answer
2. Look for the "Response to Updating drop down based on previous cell" thread
3.select it
4.download the attached file

Cant get Attached file

Submitted by harish on 8 December, 2012 - 09:14.

Hi Andy,

As I am new to this forum I could not get the attached file at the location that you have specified.Could you plz mail that attachement to my mail..Id: harish753@gmail.com

Thanks in advance.

Done... :-)

Submitted by AndyLitch on 8 December, 2012 - 09:21.

Done... :-)

Nedd Lists for these data

Submitted by harish on 8 December, 2012 - 09:37.

Hi Andy,

Thank you so much.But how i can relate this to my requirement
Can you generate for this data.

OS Versions

Windows 8
Windows 7
Windows Vista
Windows XP SP3
Windows XP SP2 (32-bit)
Windows XP SP2 (64-bit)
Windows Server 2008
Windows Server 2003
Windows 2000 SP4
Mac OS Intel 10.8
Mac OS Intel 10.7.2 - 10.7.5
Mac OS Intel 10.7 - 10.7.1
Mac OS Intel 10.6.4 - 10.6.8
Mac OS Intel 10.6 - 10.6.3
Mac OS Intel 10.5.8
Mac OS Intel 10.4.11 - 10.5.7
Mac OS PowerPC 10.4.11 - 10.5.8

******************

Locales

English
English (UK)
French
German
Hebrew
Hungarian
Italian
Japanese
Korean
Portuguese
Romanian
Russian

*********

Versions

7.0
7.1.8
8.9
9.0
9.5.6
10.1.4
11.0

These are the details and the size varies based on these three combinations..

When I select first cell(Locale)2nd drop down with list of OS versions for that Locale should be populated after that if i select an OS all available versions for that Locale and OS should be populated and then If I select a version from that size should be auto populated..