+ Reply to Thread
Results 1 to 2 of 2

Worksheet creation triggers addition of data to master sheet??

  1. 03-08-2011, 05:32 PM #1
    Hellraiser is offline
    Registered User
    Join Date
    03-08-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Worksheet creation triggers addition of data to master sheet??

    Vague subject line I line....anyway I have this "master" worksheet that I want to display data that is pulled from other sheets (ie:sheet2!E4) etc. Basically the other sheets are raw data that hold times of specific tests run on a web app. I average the times in the sheets and those numbers are displayed on the master sheet for analysis.

    What I want to do is whenever I add a new sheet to the document, I would like excel to auto populate the mastersheet with the correct format and correct cell/sheet reference according to the newly created sheets name. See pic for clarification.
    I don't even know if this is possible; I've googled and haven't found what I needed.

    Thanks
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 03-08-2011, 05:55 PM #2
    MarvinP is online now
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,239

    Re: Worksheet creation triggers addition of data to master sheet??

    Hey Hellraiser,
    I have two possible answers.
    1. Put all your data on a single sheet. Make sure you have a date column and then you might be able to do your reports from this single table.
    2. If you really need a sheet per day then VBA code might be able to handle it with indexes. The secret is that the worksheets are indexed from left to right by tabs. Worksheets(1) is the leftmost tab sheet and Worksheets.Count is the last one. In VBA code you could write generic code that would accumulate your master sheet no matter how many other tabs as you can do them with a loop.

    If you attach a real workbook, it would be easier to see which method might work.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1