+ Reply to Thread
Results 1 to 1 of 1

Create clone copy of one year's formula formatting for a new year

  1. #1
    Registered User
    Join Date
    09-11-2009
    Location
    Bluffton, South Carolina
    MS-Off Ver
    Excel 2003
    Posts
    12

    Create clone copy of one year's formula formatting for a new year

    I have an Excel spreadsheet containing a large amount of formulas applicable to 2009. I want to create a duplicate workbook for 2010. I want to maintain all cell formatting, ie A1=sum(whatever) without retyping it all. When I attempt to use copy-and-paste (or paste special) from 2009 to 2010, the cell values maintain a reference to the 2009 workbook. For example on 2010 workbook, A1=[2009]sum(whatever). Therefore the values from 2009 print in cells. I only want to maintain cell formula formatting, not a reference back to 2009 workbook. How do I do this? I hope I have been clear. Just to clarify further, the result I would like to see is the same formatting from all of my 2009 workbooks (I have corrected earlier syntax error mentioned by responder), with all of the same underlying formulas into a new 2010 workbook that will have zero value until I enter something in the appropriate box. I want 2010 to be a blank slate (data values) but an exact copy of 2009 formatting and formulas; also maintaining the 2009 workbook completely. Will this work or does this further clarify into a different answer? BTW, thank you for your previous reply and understand that all of the emphasis in this second post is just for clarity's sake.
    Last edited by DarCady; 09-12-2009 at 07:14 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1