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

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


Gord Dibben MS Excel MVP

On Mon, 4 Jan 2010 07:31:01 -0800, crystal_ns
wrote:

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!