+ Reply to Thread
Results 1 to 2 of 2

Help populating a cell formula (totals) on new tabs to infinity on a final page

  1. #1
    Registered User
    Join Date
    11-21-2014
    Location
    CA
    MS-Off Ver
    14.1, yr 2011
    Posts
    1

    Help populating a cell formula (totals) on new tabs to infinity on a final page

    Hi everyone, first post here.

    I am creating a change order worksheet for work. The overall goal here is to be able to create new tabs with the same template (which I believe I can do), and have the total at the bottom of the change order worksheet be able to total on the last tab which is the final totals worksheet… Essentially one cell from each tab that populates in the final sheet.

    The kicker is being able to open a new tab, with the template already there, and have the total automatically populate on the final sheet. Can this be done? Is it some cell function for all tabs to infinity?

    Thank you all for your time reading this and any response you can offer.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Help populating a cell formula (totals) on new tabs to infinity on a final page

    Welcome to the forum.

    Can you post a sample data set with a sample or proposed solution tab (and you can just have typed in numbers instead of formulas) so we can see what you are trying to accomplish?

    Also, are you using a MAC, if so I am not sure how much I can help because I am not familiar with it at all?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ 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] Formula for working out and populating a table using the previous month totals
    By amasson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2014, 11:12 AM
  2. Replies: 5
    Last Post: 07-06-2012, 08:25 AM
  3. replacing lowest test grade with final if final is higher formula help
    By colbyclay in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-16-2012, 02:48 AM
  4. [SOLVED] summarise totals from many worksheets into one final worksheet
    By NAAPS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2006, 10:45 AM
  5. Replies: 0
    Last Post: 11-22-2005, 10:50 AM

Tags for this Thread

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