add data t drop down list use a different worksheet same workbook
 

If you name the list, you can refer to it in data validation on a different
sheet. There are instructions he

http://www.contextures.com/xlDataVal01.html

If the list will change size, you could use a dynamic name, as described he

http://www.contextures.com/xlNames01.html
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


"Drop down list" wrote:

I want to add a value in a drop down list and I use a different worksheet in
the same workbook

How do I process to allow me to have all the value in my worksheet. I
cannot see the new date