L
Legacy 53668
Guest
I'm trying to create a rolodex in excel. My spreadsheet consists of two tabs called database and rolodex. The database tab consists of columns with account numbers, names, address, phone numbers etc. The rolodex tab will allow a user to select one account and only pull in information for that one account. My problem is that I would like to design the spreadsheet so that the user can select from a drop down list of either account numbers or account names. I can design it so that they select one of these options, but I can't figure out how to give them the ability to select either one. Ideally I would have a pop up box (similar to the way a calendar would work), where I would see account numbers and names, and the user can sort on either numbers or names an select the appropriate one. Any ideas?