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

Copy without linking 1
Merge Multiple workbook sheets into one workbook 0
Copy sheet 2
How to AUTOMATICALLY complete an Excel array.... 11
Sheet copy limit 3
reset a workbook each month saving a copy and using totals to rest 1
Excel 2007 - Linking 1
Macro to Copy Sheets to new workbook 18

Top