I need help to enable the following scenario (Excel 2007):
My spreadsheet utilizes a variety of lists contained on a separate sheet/tab
Most are simple drop-down, select, done
But I have one column where I want the cells populated based on the drop down selection in the previous cell.
Among the lists in the workbook, there are two lists (example) called TEAMID and TEAMNAME. I would like to select TEAMID from a drop-down/list and have that selection drive the population of the teamname cell so that TEAMNAME is never manually selected and TEAMID and TEAMNAME are always in sync.
Example:
(selected) (populated)
TEAMID TEAMNAME
RT00112 Red Team 2
PT00110 Purple Team 0
BT00111 Blue Team 1
GT00113 Green Team 3
BT00114 Blue Team 4
GT00114 Green Team 4
PT00114 Purple Team 4
GT00116 Green Team 6
GT00113 Green Team 3
RT00113 Red Team 3
GT00116 Green Team 6
PT00110 Purple Team 0
BT00112 Blue Team 2
RT00112 Red Team 2
PT00115 Purple Team 5
I'm not a programmer so responses should not be too technical please.
Thanks,
robbg
Bookmarks