Drop-down menus to store different data

W

workerboy

Hi,

I was wondering if it was possible to use a drop down menu to stor
different data for each item in the drop down list. For example if
had a drop down list with options CATS, DOGS. For both of the two
want to have exactly the same column header names (eg. No. of Pets, No
of Blue eyes etc).

I want to be able to choose dogs and update all DOGS fields and vic
versa (all storing just numbers). Then I should be able to extract th
information needed for CATS and DOGS later as needed.

This should allow lot of information to be stored in a worksheet.

Thanks if anyone can help me out with this
 
D

Debra Dalgleish

You can use the Data>Filter>AutoFilter command to apply dropdown lists
to the top row of a table. Then, select an item from one of the dropdown
lists, and only those items are visible in the table.

Update the visible records, then choose Data>Filter>Show All, to see all
the records.
 
Top