Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |