Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Feb 2005
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formulas (Excel 2003)

    When I set up an excel sheet with formulas, is there anyway that I can copy this and put it on a new page? For ex: if I set up a format that I want to use every month, but starting with a 0 balance each month. There are several places that I have a formula within in the page. I would like to be able to transfer the formulas without having to redo each one. Is this possible? The formulas are going across the page for a total, not down the page if that makes a difference.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (Excel 2003)

    The easiest thing would be to create the "template" sheet with no data, just the formulas. Never put data in this sheet. When you need a new sheet for data, Use the "Move or copy sheet" command from the Edit menu (or right click on the sheet tab and use the same command from the popup menu) to create a copy of the sheet. You could create a macro to cerate the new sheet and keep the template sheet hidden.
    Legare Coleman

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formulas (Excel 2003)

    As Legare has said, the best way to achieve this is to use a template. Another method is to save a blank version of your formula sheet (without data, just formulas), as a template. When you have the sheet active, choose File : Save As, and change the file of type option to Template (*.xlt). Whenever you need a new 0 balance copy of the sheet, simply choose File : New, and select your template in the General Tab category.
    Regards,
    Rudi

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (Excel 2003)

    Unfortunately, that will create a whole new workbook, not just a new worksheet.
    Legare Coleman

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formulas (Excel 2003)

    You are correct...sorry, I overlooked that rather large detail!!! - <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    Regards,
    Rudi

  6. #6
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (Excel 2003)

    Rudi's method of saving the formula sheet as a one-sheet template file will work if, instead of choosing 'File:New', you Right-Click on a sheet tab and choose 'Insert...'

    This will access a templates dialog where you can choose the template file previously saved and it will be inserted as a sheet in the current file.

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (Excel 2003)

    You are correct, I did not know that. This might be a good solution for this user.
    Legare Coleman

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formulas (Excel 2003)

    That is a great tip Tony...
    I too did not know this. Tx for sharing!
    Regards,
    Rudi

Posting Permissions

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