I need 20 dropdown list on the worksheet. some of drop-down lists has the
same values. I need a list thats has one set of names and worksheet has
another set of names. Here is a example want I need.
LIST names Worksheet names
Red - Black 770rb
Black-White 770bw
My list will have 15 items in each list. When user click on the color it
would take them to that worksheet.
What is best way to do this?
Bookmarks