Drop Down Menus

C

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!
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation Lists - Generating a list based on another list'sresult 2
Cut and paste with a combobox 0
date reverts to serial number 6
loop thru cells to find matching record 2
Restrict Choice in Shared WB (drop down alternative)? 0
using a conditional formula from a drop down list and If Statement 8
program drop down menus 1
Count unique values - Match and conditional IF 2

Top