+ Reply to Thread
Results 1 to 2 of 2

How to Duplicate workbook to be a template or new year workbook

  1. #1
    Registered User
    Join Date
    10-16-2019
    Location
    Illinois
    MS-Off Ver
    2013
    Posts
    3

    How to Duplicate workbook to be a template or new year workbook

    Hello

    My supervisor sent me an excel file with 12 months of numbers and formulas in it and wants me to duplicate it without the numbers but to keep the formulas so can have it for next year.

    How to go about that without going sheet to sheet and change the formulas manually.

    I am thinking it should be more generic so each year don't have to do this and will have just a template to use for each year.

    How to go about it?

    Thinking might get more from her and would like to be able to do this with any workbook get.



    David

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,343

    Re: How to Duplicate workbook to be a template or new year workbook

    You have the advantage of knowing what the workbook, worksheets, formulae and data, etc., look like.

    We don't.

    You could use F5 (Go To) on each sheet, select Special and flag Constants. Then press Delete.

    As to the formulae, who knows how they need adjusting without seeing them. It could be just a Global Replace of a year.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Create a new workbook from a template worksheet using information from main workbook.
    By nathandavies9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2017, 11:28 AM
  2. [SOLVED] Want auto-gen number in template workbook to stop working when saved to normal workbook
    By tjamestx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2014, 02:56 PM
  3. Copying specific rows from workbook containing data to a template workbook
    By mattyp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-18-2014, 10:06 AM
  4. Opening Template as new workbook and not Blank Workbook from listbox
    By MB_vba in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2013, 04:27 PM
  5. Replies: 2
    Last Post: 01-06-2013, 04:27 PM
  6. Macro, copy UNLOCKED cell range of sheet in open workbook to workbook template
    By NicksDad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2012, 11:18 AM
  7. Save an open workbook, then open template workbook and close the saved workbook
    By ondvirg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2009, 10:20 PM

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