Maybe you could type the list into the data|validation dialog.

Maybe you could put the list on the same sheet (in an out of the way spot) so
it, too, gets copied.

Maybe you could copy the other sheet (with the validation) at the same time.

Marlis wrote:

I have a template that I created with a drop down list using validation from
within the same book. How I can get the validation to work when I move the
sheet to another book? (I get a value error when it updates)
Thank you

--

Dave Peterson