+ Reply to Thread
Results 1 to 4 of 4

Simple formulas linked to multiple worksheets

  1. #1
    Registered User
    Join Date
    11-21-2011
    Location
    Beaumont, Texas
    MS-Off Ver
    Excel 2003
    Posts
    1

    Simple formulas linked to multiple worksheets

    I'm trying to improve a spreadsheet that tracks auto mileage weekly. Each week is represented by a different worksheet. Each Monday I add another worksheet that represents data for the previous week. I would like to create a new worksheet that will accumulate the totals from all worksheets as well as the new ones that are added weekly. Is this possible? Or will I have to create 52 sperate sheets prior to developing the cumulative sheet?

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Simple formulas linked to multiple worksheets

    If the cells you want to add are all in the same location on each sheet, you can do something like: =SUM(Sheet1:Sheet2!A1). All you need to do is create a blank worksheet as a buffer between the rest of the spreadsheets and the summary, have the formula go from the first spreadsheet through the buffer, and then insert new spreadsheets before the buffer. Does that make sense?
    Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.

    If you like a post, please rate it with the scales icon (top right).
    If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Simple formulas linked to multiple worksheets

    Hi,

    Why not just use a single sheet that holds all data, and with an extra column to hold the date of each transaction. i.e. build a proper database which can then be used in all sorts of ways for analysing and reporting. This will be far more efficient than having to worry about a sheet for each week and much more flexible.

    Regards
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Simple formulas linked to multiple worksheets

    Depending on how much data you have per week and whether you can lay it out as Richard suggests, he brings up a good point. If you could have it all in one place, you could have a pivot table in another sheet to bring up any given week, add it up by month, or manipulate it in other ways.

+ 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