help??

[WTG]

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

 

[Anne Troy]

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]

Thanks I'll give it a try

Wally

If you're copying over successfully, can you paste special as values instead
of plain paste?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com