| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook with 40 sheets, want complete copy without formulaes
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 -- Johannes |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook with 40 sheets, want complete copy without formulaes
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" wrote in ... 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 -- Johannes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy all sheets to a new workbook | Setting up and Configuration of Excel | |||
| Copy several sheets from one workbook into another at the same tim | Excel Discussion (Misc queries) | |||
| copy formulaes w/o filename | Excel Discussion (Misc queries) | |||
| copy workbook sheets? | Setting up and Configuration of Excel | |||
| copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
Linear Mode
