Watch this 5 min video:

How to setup a data validation drop down list:

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

--
Biff
Microsoft Excel MVP


"Neil M" wrote in message
...
Is there a work around to creating lists on wroksheets from other
worksheets.
I would like to have one worksheet with all my reference lists and data on
it.