If you're copying over successfully, can you paste special as values instead
of plain paste?
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"WTG" wrote in message
...
I've filled my worksheet with the proper information using vlookup to
access info from other worksheets.
Now I want to save some of that information to another worksheet.
I can do this and so far no problems,
But when I Clear or change the information on the first worksheet all
my information on the second sheet either changes to or I get REF#.
How can I copy the info over to stay, so it won't change when i clear
the first sheet.
Thanks
Wally