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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
>
>
>
>
>

[WTG]

Thanks I'll give it a try

Wally


On Wed, 29 Jun 2005 18:15:33 -0400, "Anne Troy"
<[email protected]> 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" <[email protected]> wrote in message
>news:[email protected]...
>>
>> 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
>>
>>
>>
>>
>>
>>
>>
>