Hi

Assuming the users are capable, the easiest way would be to tell them to
click of the small grey cell to the left of A and above Row 1 of the new
sheet. This will select all of the cells.
Copy
Move to cell A1 of the existing second sheet and Paste.
This will replace all of the named ranges with the new values.

--
Regards

Roger Govier


"DocBrown" wrote in message
...
I have a worksheet with named lists. I have a second worksheet that has
validation references (=listname) to those lists to create dropdown
lists.
This is working fine. I have now distributed this spreadsheet to
multiple
users.

I want to now update one or more lists in my master file and
re-distribute
the list worksheet and give the users a method to replace the lists
worksheet
in their local copy.

What is happening is that when I copy the updated list to the local
worksheet, and delete the original list worksheet, the second
worksheet no
longer sees the named lists. The same thing happens if I first delete
the
list worksheet and then copy the new list worksheet. The lists are
still
correctly visable in the lists worksheet.

How do I get the second worksheet to see the named lists again?