I am not sure I got what you mean, but if I am right, this is for you!

you want to use drop down list from another worksheet, but in the same
workbook, so that if you modify this list, the one from the other
worksheet is modify as well. The trick is to simply use the very same
one!

You can name a drop down list by selecting the cells and giving it a
name in the upper-left corner (name box, where you see A4 and so
on...). Do not forget to press ENTER, or the name change will not
occur.

Then, with the validation menu, you select "list" and simply enter
"=(name of your list". Like this, you have a single source for your
list in all the worksheets, instead of typing it for every cells and
having to change it everywhere if an update is needed.

Hope this is useful... or maybe your problem is not what I gathered...


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=556967