Results 1 to 2 of 2

Thread: VBA SUMIFS Across Multiple Sheets
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2018
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA SUMIFS Across Multiple Sheets

    Hi Everyone,

    I have a master spreadsheet that has names of 5 employees down from Column A (First name starts Cell A2).
    Going Across From Column B1 : K1 I have Months (Jan - Dec)

    Name Jan Feb Mar Apr May Jun July Aug Sep Oct Nov Dec
    Rob
    Bob
    Bill
    Will
    Phil

    Then I have multiple tabs ( each get created once someone clicks the new project button from a different tab ) the naming convention of the tabs when they click the button go from 1, 2, 3, 4, and will be a forever growing list.

    Each of those tabs has the same format as the master above however not all those names will be in every tab, some tabs may only have 1 employee, while others may have 3 employees listed.

    My goal: Create a Macro that will SUMIFS on the master tab, all the tabs ranging from 1 - (infinity) into the corresponding spot in the master table. So the sum range will be from each of those tabs ("B2:K5"), Criteria Range 1 ("A:A"), Criteria "Master"(A2), Criteria Range 2 (B1:K5), Criteria 2 "Master"(B1),

    Is it possible to create a macro that can loop through multiple tabs and give you the sum across all those tabs based on the following criteria?


    Thank you for your help.

    Best Regards,

  2. #2
    Board Regular
    Join Date
    Mar 2018
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA SUMIFS Across Multiple Sheets

    So after playing around with it some more... I can do a Index(Match) based on name,(Match) based on date, and then do a + across all the sheets....
    How can I do this with VBA so that it'll perform that formula for the all existing tabs (1 - through whatever number is created at the name)

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •