pop up box

[cbell11]

I would like to be able to have a pop up box appear in a spreadsheet when I
am on column A that would actually show dropdowns for all of the first three
columns on my report, that would allow my salespeople to pick criteria for
these columns, for example, customer name, contact and city. This information
is all on a second worksheet in the workbook. At present all I have been able
to figure out is how to have a dropdown list for an individual column.
Any ideas?
Thanks

 

[John]

Hi
Check out in Help "Data Validation and Vlookup" then post back with more
details
HTH
John

 

[Shane Devenshire]

Hi,

You would need to program Excel using VBA to do what you want. Is that an
acceptable solution? Much easier would be to turn on Data, Filter,
AutoFilter in which case the user will need to select from three drop downs
at the top of the columns.

 

[That One Guy]

Is customer name, contact, and city already fixed, meaning that you
already know the customer name, contact, and city, or are you trying to
have your sale's people research what the contact and city per customer
name should be.

If the former (all contact information is already known), than I think
all you need to do is concatenate all three columns into one column, and
then assign the consolidated column a name (this can be done by typing a
name where you see the actual range, usually in the upper left of
Excel). You can then, if needed, use vlookup (or if you want no #na
errors, use =if(isna(match([matchcriteria]))=true,"",vlookup([vlookup
criteria]))

If, however, you are asking sales to enter the customer name, city, and
contact, than what you need is either an Access solution or some sort of
form and a VBA solution
(http://exceltip.com/st/Create_User_Forms_in_Microsoft_Excel/629.html is
a comprehensive tutorial that can introduce you to VBA and using Excel
Forms as a solution).

Regards,

That One Guy