Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Link To Drop Down Menu
I have a cell with a drop down menu with Contract Types. I want cells to
populate with data elsewhere on a worksheet if this drop down cell = T&M. Please see example below to better explain. Worksheet A A 1 T&M (drop down cell) 2 3 Tim Jones 4 Donna Jones 5 Jane Doe 6 John Black Worksheet B A 1 if A1 in Worksheet A = T&M I want this cell to equal A3 from worksheet A 2 if A1 in Worksheet A = T&M I want this cell to equal A4 from worksheet A 3 if A1 in Worksheet A = T&M I want this cell to equal A5 from worksheet A 4 if A1 in Worksheet A = T&M I want this cell to equal A6 from worksheet A If A1 is not = to T&M, I'd like A1:A4 to be left blank Thanks! Jana |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with drop down menu | Excel Worksheet Functions | |||
How to create a drop down menu which referencing a different workb | Excel Discussion (Misc queries) | |||
How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
Drop down menu | Excel Discussion (Misc queries) | |||
link drop down menu to info in worksheet | New Users to Excel |