Drop Down Menus

[crystal_ns]

I need to create a spread sheet with multiple drop down menus that will do
the following:
When selecting the drop down from the tab there is a list of serial numbers,
when each serial number is selected just information for that serial number
will come up...ie

Serial Number User Date Account Number etc for just the item selected
Can someone PLEASE help me with this...completely clueless!

 

[Ryan H]

You could use 2 options:

1.) You could highlight the column with the serial numbers and turn on the
AutoFilter. Then select the serial number you wish to view.

2.) Or you could setup a user form with a ComboBox which contains all your
serial numbers and TextBoxes that will show all the data pretaining to the
serial number selected.

You seem to be a newbie to Excel so I would recommend Option 1. If you want
a slightly complicated, but not too hard Option 2, let me know and I can
spend a few minutes posting code.

Hope this helps! If so, click "YES" below.

 

[Gord Dibben]

See Debra Dalgleish's site for help on "dependent dropdowns".

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP