Updateable drop-down menu for an item database?
 

Hello, I have a database of items that I am keeping track of. Each item falls
into a certain catagory (e.g. office, toy, household, cleaning, etc....)

I'd like to have a certain column be dedicated to providing the drop down
catagory list. So as an example, cell C1 and C2 would be the column header,
C3 - infinity would automatically contain the drop down menu.

This menu also needs to be updateable so I can add additional catagories
later in the future. How do I do this?

Updateable drop-down menu for an item database?
 

Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

This menu also needs to be updateable so I can add additional catagories
later in the future. How do I do this?

Use a dynamic range:

http://contextures.com/xlNames01.html#Dynamic

--
Biff
Microsoft Excel MVP


"phillr" wrote in message
...
Hello, I have a database of items that I am keeping track of. Each item
falls
into a certain catagory (e.g. office, toy, household, cleaning, etc....)

I'd like to have a certain column be dedicated to providing the drop down
catagory list. So as an example, cell C1 and C2 would be the column
header,
C3 - infinity would automatically contain the drop down menu.

This menu also needs to be updateable so I can add additional catagories
later in the future. How do I do this?