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
|