How do you create drop down boxes?
For example, i want to be able to pick from 3 sales reps: jones, smith, and clark.
When I pick one (for example "Smith") his information( for example phone number and address) will appear on another workbook tab.
I have heard of a VLOOKUP command (but I am not familiar with it)Do you use that?
Lastly, How do you make a workbook tab hidden and unhidden?
I wonder if these questions will stump many people??
Thanks all for your help!
Exzel
For example, i want to be able to pick from 3 sales reps: jones, smith, and clark.
When I pick one (for example "Smith") his information( for example phone number and address) will appear on another workbook tab.
I have heard of a VLOOKUP command (but I am not familiar with it)Do you use that?
Lastly, How do you make a workbook tab hidden and unhidden?
I wonder if these questions will stump many people??
Thanks all for your help!
Exzel