Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
copy workbook sheets?
Have 13 sheets in workbook, ME2005, 1x each month and 1x summary sheet. Each
month has 68 rows for each customer and columns for deposits, date and amount and adding that to a summary page with checks and balances formulas. Starting new year in '06 and would like to transfer format and formulas but NOT values from ME2005 to a new workbook named ME2006. OR use a copy of the '05 workbook and delete all values, in mass, and rename workbook to ME2006 w/o losing formulas. I tried to copy('05) and special paste format and then formulas into new '06 workbook BUT values pasted also when I special pasted formulas. Suggestions please, L. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
copy workbook sheets?
Open workbook ME2005.
Open a blank workbook and name it ME2006. With ME2005 active right-click on a sheet tab and "select all sheets" Right-click again and "Move or copy" Checkmark "create a copy" and select ME2006 as the copy to book. OK. The sheets will be copied to ME2006. Close ME2005(so confusion doesn't arise). With ME2006, right-click and Select all sheets. F5SpecialConstants. Choose the constants to select. You will probably want to keep titles etc. Hit OK and EditClear Contents to clear out data and leave formulas. DO NOT FORGET to right-click and "ungroup sheets" or you can have disastrous results. When grouped, what you do to one sheet will be done to the others. If you have any titles or such that read 2005, you can EditReplace with 2006. Gord Dibben Excel MVP On Fri, 25 Nov 2005 13:40:38 -0600, "L." wrote: Have 13 sheets in workbook, ME2005, 1x each month and 1x summary sheet. Each month has 68 rows for each customer and columns for deposits, date and amount and adding that to a summary page with checks and balances formulas. Starting new year in '06 and would like to transfer format and formulas but NOT values from ME2005 to a new workbook named ME2006. OR use a copy of the '05 workbook and delete all values, in mass, and rename workbook to ME2006 w/o losing formulas. I tried to copy('05) and special paste format and then formulas into new '06 workbook BUT values pasted also when I special pasted formulas. Suggestions please, L. |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
copy workbook sheets?
Slapping forehead<g
With ME2005 open do a fileSave As ME2006 then start at the point where you select all sheets and F5SpecialConstants. Gord On Fri, 25 Nov 2005 12:07:52 -0800, Gord Dibben <gorddibbATshawDOTca wrote: Open workbook ME2005. Open a blank workbook and name it ME2006. With ME2005 active right-click on a sheet tab and "select all sheets" Right-click again and "Move or copy" Checkmark "create a copy" and select ME2006 as the copy to book. OK. The sheets will be copied to ME2006. Close ME2005(so confusion doesn't arise). Start here after save as ME2006 With ME2006, right-click and Select all sheets. F5SpecialConstants. Choose the constants to select. You will probably want to keep titles etc. Hit OK and EditClear Contents to clear out data and leave formulas. DO NOT FORGET to right-click and "ungroup sheets" or you can have disastrous results. When grouped, what you do to one sheet will be done to the others. If you have any titles or such that read 2005, you can EditReplace with 2006. Gord Dibben Excel MVP On Fri, 25 Nov 2005 13:40:38 -0600, "L." wrote: Have 13 sheets in workbook, ME2005, 1x each month and 1x summary sheet. Each month has 68 rows for each customer and columns for deposits, date and amount and adding that to a summary page with checks and balances formulas. Starting new year in '06 and would like to transfer format and formulas but NOT values from ME2005 to a new workbook named ME2006. OR use a copy of the '05 workbook and delete all values, in mass, and rename workbook to ME2006 w/o losing formulas. I tried to copy('05) and special paste format and then formulas into new '06 workbook BUT values pasted also when I special pasted formulas. Suggestions please, L. |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
copy workbook sheets?
Thanks, will give it try.
Hope this applies to Office(excel) 2k. Forgot to mention that. L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Slapping forehead<g With ME2005 open do a fileSave As ME2006 then start at the point where you select all sheets and F5SpecialConstants. Gord On Fri, 25 Nov 2005 12:07:52 -0800, Gord Dibben <gorddibbATshawDOTca wrote: Open workbook ME2005. Open a blank workbook and name it ME2006. With ME2005 active right-click on a sheet tab and "select all sheets" Right-click again and "Move or copy" Checkmark "create a copy" and select ME2006 as the copy to book. OK. The sheets will be copied to ME2006. Close ME2005(so confusion doesn't arise). Start here after save as ME2006 With ME2006, right-click and Select all sheets. F5SpecialConstants. Choose the constants to select. You will probably want to keep titles etc. Hit OK and EditClear Contents to clear out data and leave formulas. DO NOT FORGET to right-click and "ungroup sheets" or you can have disastrous results. When grouped, what you do to one sheet will be done to the others. If you have any titles or such that read 2005, you can EditReplace with 2006. Gord Dibben Excel MVP On Fri, 25 Nov 2005 13:40:38 -0600, "L." wrote: Have 13 sheets in workbook, ME2005, 1x each month and 1x summary sheet. Each month has 68 rows for each customer and columns for deposits, date and amount and adding that to a summary page with checks and balances formulas. Starting new year in '06 and would like to transfer format and formulas but NOT values from ME2005 to a new workbook named ME2006. OR use a copy of the '05 workbook and delete all values, in mass, and rename workbook to ME2006 w/o losing formulas. I tried to copy('05) and special paste format and then formulas into new '06 workbook BUT values pasted also when I special pasted formulas. Suggestions please, L. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
copy data in one sheet to multiple sheets in same workbook | Excel Worksheet Functions | |||
How can I Copy cell names from one workbook to another? | Excel Discussion (Misc queries) | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions |