Updating drop down based on previous cell

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..

how to see the response in

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

1.Go to Forums -> Question

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

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... :-)

Done... :-)

Nedd Lists for these data

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..

Almir's picture

Updating drop down based on previous cell

This can be accomplished through data validation. I need a list of all locales, OSs and versions, in order to generate lists of unique values for all three columns.

OS Versions Windows 8 Windows

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..

See the response on a separate thread

See the response on a separate thread

Almir's picture

I think Andy has already sent solution

Thanks to Andy.