How do I save a sheet's data into a new file?

Posted by Tom on July 06, 2000 12:57 PM

Here's what I am trying to do...

Sheet2 has data being logged from sheet1 and I need to save the data occasionally into a new file and clear the "old" data w/out affecting the current file. How is this done?

Any help is greatly appreciated!

Tom.

Posted by mike faulkner on July 07, 0100 10:14 AM

I think he meant that in the new file he has linked data from the original file and wants to keep the data but "unlink" it.

All he has to do is COPY then PASTESPECIAL - VALUES

Posted by Ryan on July 06, 0100 1:08 PM

Tom,
You can copy the current sheet into a new workbook and save the new workbook. If you're looking for some code, let me know.

Ryan