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

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

Thanks I'll give it a try

Wally


On Wed, 29 Jun 2005 18:15:33 -0400, "Anne Troy"
wrote:

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