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