Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: How to create a Summary tab off multiple tabs with similar data

  1. #1
    New Member
    Join Date
    Nov 2017
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to create a Summary tab off multiple tabs with similar data


    How can I create a summary tab using multiple tabs with similar data? I have laid out 3 tabs below, "John", "Andrew", and "summary". I would like the summary tab to look up off of over 50 different tabs. See below, thank you in advance!

    Tab Name: John
    A B C D
    1 Name John
    2
    3 Birth Date 1/1/2005
    4 Favorite Food Pizza
    5 Sport Soccer
    Tab Name: Andrew
    A B C D
    1 Name Andrew
    2
    3 Birth Date 12/6/2004
    4 Pet Dog
    5 Favorite Food BBQ
    6 Sport Tennis
    Summary Tab
    A B C D E
    1 Name Birth Date Pet Favorite food Sport
    2 John 1/1/2005 Pizza Soccer
    3 Andrew 12/6/2004 Dog BBQ Tennis

  2. #2
    New Member
    Join Date
    Nov 2017
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to create a Summary tab off multiple tabs with similar data

    thank you in advance

  3. #3
    New Member
    Join Date
    Oct 2017
    Posts
    24
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to create a Summary tab off multiple tabs with similar data

    How about just create a summary tab and reference each sheet?

    Summary Tab:

    Cell A2: = John!A2
    Cell B2: = John!B2
    Cell C2: = John!C2

    Cell A3: = Andrew!A3
    Cell B3: = Andrew!B3
    Cell C3: = Andrew!C3

  4. #4
    New Member
    Join Date
    Nov 2017
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to create a Summary tab off multiple tabs with similar data

    thank you - I was hoping to find a quicker way as there are 50 different tabs and 50 different names - would be a lot of legwork in my opinion to link each tab by itself.

  5. #5
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    14,036
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    6 Thread(s)

    Default Re: How to create a Summary tab off multiple tabs with similar data

    Why is row (2) empty?
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  6. #6
    New Member
    Join Date
    Nov 2017
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to create a Summary tab off multiple tabs with similar data

    no reason, just spacer row.

  7. #7
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    14,036
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    6 Thread(s)

    Default Re: How to create a Summary tab off multiple tabs with similar data

    It just makes things like your asking for harder. And like why does name go in column "B" but all other data goes in column "E"

    Laying out how you do things can be important when some day you want to do things like your asking for.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  8. #8
    New Member
    Join Date
    Oct 2017
    Posts
    24
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to create a Summary tab off multiple tabs with similar data

    vba is not my expertise, but you could loop all worksheets to pull range and copy it to target sheet "Summary".

    https://msdn.microsoft.com/en-us/lib...ffice.12).aspx

  9. #9
    New Member
    Join Date
    Nov 2017
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to create a Summary tab off multiple tabs with similar data

    Thank you. Is there a quick way to reference a tab name? Instead of finding and replacing on a vlookup over 50 times?

  10. #10
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    14,036
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    6 Thread(s)

    Default Re: How to create a Summary tab off multiple tabs with similar data

    Sure a loop would work.

    But there are several problems here:

    For example John does not have a Pet so there is no row for Pet
    But Andrew does have a Pet so there is a row designated for pet.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

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
  •