+ Reply to Thread
Results 1 to 4 of 4

NEw tabs, auto updating summary tab

  1. #1
    Registered User
    Join Date
    09-22-2013
    Location
    New England
    MS-Off Ver
    Excel 2007, 2010 & 2013
    Posts
    24

    NEw tabs, auto updating summary tab

    In a previous thread, the self naming dated macro tab works like a charm. Its been super easy to generate data every day but now I am having difficulty coming up with a formula or macro to have the summary tab automatically update with the new tabs. I need the same cells from each new tab. Copying and pasting links is one way, I've attempted and failed with trying to DEFINING NAMES and am stuck.

    Basically, in the attached file, I need the # Error from each newly dated tab to self populate on the summary tab and include the date. The locations are the same cells on all the tabs.

    Hopefully this is easy for someone with more experience than me.

    Thanks MP
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-22-2013
    Location
    New England
    MS-Off Ver
    Excel 2007, 2010 & 2013
    Posts
    24

    Re: NEw tabs, auto updating summary tab

    Just bumping.

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: NEw tabs, auto updating summary tab

    There is probably a better way, but the easiest solution for me was to create a
    macro that clears, and then creates the 'Summary' Sheet from scratch, and includes all
    the formulas. There is a button in the 'Template' Sheet that calls the macro that creates
    the 'Summary' sheet.

    See the attached file written and tested in Excel 2003, but it should work for your version.

    Please NOTE that in your file, the "Summary" Tab was spelled incorrectly.

    Lewis

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    09-22-2013
    Location
    New England
    MS-Off Ver
    Excel 2007, 2010 & 2013
    Posts
    24

    Re: NEw tabs, auto updating summary tab

    This will make my life easier. Thanks for your help.

+ 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] Summary Sheet Different Tabs
    By Scorpiopaul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-02-2013, 09:12 AM
  2. Replies: 4
    Last Post: 05-02-2013, 04:39 PM
  3. Help with automatic chart updating/auto updating today function
    By Tux2424 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-26-2012, 04:45 PM
  4. Using checkboxes on summary sheet to name tabs and hide/unhide tabs
    By eew2201 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2012, 06:13 PM
  5. Macro for creating tabs linked to auto summary
    By dscape in forum Excel General
    Replies: 0
    Last Post: 05-21-2009, 06:33 AM

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