List for multiple sheets

  • Thread starter Thread starter Vivek Sharma
  • Start date Start date
V

Vivek Sharma

Hi There,

I have a sheet where I have few lists such as Revision Number, Status, etc.
I want to use them as a drop down list on the other excel sheets. How can I
achieve this?

Please help.

Thanks
Vivek
 
Define a name for the particular list and use that name in the Data /
Validation... function (it sounds like you know how to do this part).

One way to define a name (easiest):
Select the cells you want to use for your list.
In the Name Box type in the name you want to call the selected cells then hit
the 'Enter' key.
Done!

Another way is by going through the main menu --> Insert / Name / Define...

Now when you use Data / Validation... select List in the "Allow:" drop-down
box. In the "Source:" box type in the defined name that you created in the
step above.
 
DOH! Yep, that is correct...I've used this process several times, you'd think
I would've remembered that :-)
--
Toby "Now...where did I leave my head?" Erkson
Oregon, USA
Excel 2002 in Windows XP

Don Guillett said:
In the "Source:" box type in the defined name that you created in the

Use the = sign first.
Click to expand...
....
 
Back
Top