Workbook with 40 sheets, want complete copy without formulaes

J

Johannes

Have workbook with 40 sheets, each with monthly figures to total column. I
want to make a copy every month without all the lookup and other formulaes
which I can distribute to owners
Any suggestions and thank you
 
A

AltaEgo

Select
Copy
Select top left cell in new location


XL2003
Edit, paste special, values
Edit., paste special, formats
Edit, paste special, column widths.

XL2007

http://office.microsoft.com/en-us/excel/HP012164151033.aspx?pid=CH100648341033--Steve"Johannes" <[email protected]> wrote in messageHave workbook with 40 sheets, each with monthly figures to total column.I> want to make a copy every month without all the lookup and other formulaes> which I can distribute to owners> Any suggestions and thank you> --> Johannes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Merge text from multiple sources 0
Consolidation Table from Different Excel Tabs with Different Format 1
Dealing with a Pivot Table (when I don't want to) 0
Locking Pages and/or Workbook 1
Sheet copy limit 3
Excel 2007 - Linking 1
How To Rapidly Copy Formulas? 0
Macro to Copy Sheets to new workbook 18

Top