Select one variable from a list of variables by clicking one cell

C

Curt

I am updating a Excel 2000 spreadsheet that displays a single cell to list
one of a number of verables. The cell, when clicked, displays a "down arrow"
box that then refers to the variables list from which to select. I need to
duplicate that function.
 
R

Rowan

You can do this with Data>Validation.

In the Allow box choose "List" and then in the "Source" either type in your
variables seperated by commas or enter the range that holds the list. This
can be a named range if the list is on another worksheet.

Hope this helps
Rowan
 
Top