swtbeb4lyfe43
Board Regular
- Joined
- May 1, 2009
- Messages
- 62
Hi all,
I need to make a conditional drop-down list that will show a different list depending on a value selected in another cell. For example:
On sheet 1 (titled "CC Input"), my Color Type is in cell A2: Green, Blue, Purple, etc.
On another sheet (titled "Drivers"), I have a dynamic list of values assigned to each color. Column A has Color type (Green, Blue, etc). Column B has Items (crayon, pen, paper, etc). I mean dynamic as in rows can be added or removed, but will always have a color associated in column A.
Back on "CC Input" sheet, if A2=Green, I want a dropdown in cell D1 that will pull the list of all values associated with Green from the "Drivers" worksheet.
Is this possible with named ranges & data validation? Thanks!
I need to make a conditional drop-down list that will show a different list depending on a value selected in another cell. For example:
On sheet 1 (titled "CC Input"), my Color Type is in cell A2: Green, Blue, Purple, etc.
On another sheet (titled "Drivers"), I have a dynamic list of values assigned to each color. Column A has Color type (Green, Blue, etc). Column B has Items (crayon, pen, paper, etc). I mean dynamic as in rows can be added or removed, but will always have a color associated in column A.
Back on "CC Input" sheet, if A2=Green, I want a dropdown in cell D1 that will pull the list of all values associated with Green from the "Drivers" worksheet.
Is this possible with named ranges & data validation? Thanks!