updating drop down based on previous cell


New Member
Dec 7, 2012
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
***an win7 10 78
***an mac 10.7 10.1.4 90
***an 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..


Board Regular
Nov 12, 2012

I think you asking for the data validation rules to change depending on what Locale is chosen, if this is the case then:

Create the lists on another sheet with all of the possibilities if US is chosen as the locale then another column for any other locale
Select the list that is underneath US and Define the name as US (The names have to be the same as what you will be selecting on the other sheet)
On the Sheet where you want the drop down list to appear select all the cells and go to data validation.
Type in =indirect($A$1) or whether you will enter the locale and this should give you your data validation rule.


Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...