Storing Cell Contents

[weefelly]

Hi, hope someone can help.

I have data in a cell on worksheet (1) which updates another cell on worksheet (2). I need to be able to delete worksheet (1) at a later date but keep the cell info on worksheet (2). Is there anyway that this can be done??

Thanks in advance.

[oldchippy]

Data on Sheet 2

Copy, paste special, values only