Hello
Can the following be done with Dropdown Lists.I want to make a dropdown list with 30 groups.I have 3 example groups in excel 2010 spreadsheet attached
I need the dropdown list in cell B6 - prefer not to use code if possible
From the dropdown list i can select say Smiths Wholesale in B6 and it then displays the Name,Phone,Fax and Email exactly like the spreadsheet....Can i have all the groups in Sheet 1 and the Dropdown list will be in Sheet 2
Thanks
Rich
Excel 2010
Try this..
Make a list of your group names....
Use Index+Match to lookup for the selected group, and then populate the corresponding values below that
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Thank you
Posting Permissions
Reply With Quote
Bookmarks