+ Reply to Thread
Results 1 to 4 of 4

Preparing a summary from standardised data across many worksheets

  1. #1
    Registered User
    Join Date
    11-07-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    4

    Preparing a summary from standardised data across many worksheets

    Hi, I am trying to prepare a summary sheet from information that is contained across various other tabs on the same cell each time. I have tried using SUMIF but cannot get this to work. The tabs will be the names of 100+ countries and the summary should be able to list these country names and the various bits of data in their respective worksheets.
    Initially I want to be able to pull the start and end dates automatically and then other info such as the team names, hours posted etc.
    Many thanks.
    Attached Files Attached Files
    Last edited by Robwaters1512; 11-08-2011 at 12:27 PM.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Preparing a summary from standardised data across many worksheets

    C4: =INDIRECT("'" & $B4 & "'!B3")
    D4: =INDIRECT("'" & $B4 & "'!B4")

    Copy those down...

    You'll need to adjust the dates on the other sheets to match the same year.

  3. #3
    Registered User
    Join Date
    11-07-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Preparing a summary from standardised data across many worksheets

    That's great, thanks!

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Preparing a summary from standardised data across many worksheets

    If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

+ 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