Macro to Paste Special Values, Remove Sheets and Save

Hi Guys,

I have a spreadsheet that has several worksheets, some with raw data and others with output and a Control Sheet. On the control sheet, I want to create a button that will remove all the formulas on every other sheet (paste special values) and save a copy of the file without any of the forumlas, or macros, and without the raw data sheets.

Is this possible?

Cheers,

Dex!

Hi
try the following macro codes. change file name and sheet name to suit your case. cell A1 should have the new file name.

Please Login or Register  to view this content.

run the macro. it copies all sheets and pastes special into a new workbook. Now how do you Know which is raw data and which is derivative data
ravi