LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.setup
L.
 
Posts: n/a
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
Macros for Protect/Unprotect all sheets in a workbook Paul Sheppard Excel Discussion (Misc queries) 2 August 4th 05 04:30 PM
copy data in one sheet to multiple sheets in same workbook BrianMultiLanguage Excel Worksheet Functions 4 July 27th 05 07:26 PM
How can I Copy cell names from one workbook to another? G.H.B.B. Excel Discussion (Misc queries) 1 March 24th 05 02:30 AM
How to hyperlink from a workbook to sheets in another workbook? MJOHNSON Excel Worksheet Functions 0 February 17th 05 08:31 PM


All times are GMT +1. The time now is 03:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"