+ Reply to Thread
Results 1 to 10 of 10

Combine information from different tabs

  1. #1
    Registered User
    Join Date
    11-03-2022
    Location
    Netherlands, Eindhoven
    MS-Off Ver
    2018
    Posts
    4

    Question Combine information from different tabs

    Hello all!
    Thanks for reading my help request, I have been working on this for a few hours this morning but can't figure it out.

    My goal is to create an overview (to do list) of information from different tabs. Each project has a different tab and on each of these project tabs are tasks with the responsible executor behind them.

    Now I want to create a main tab where I can insert all to do's per executor under each other from the different tabs.

    So I need the following: in main tab: if cell of row with responsible person = 'Merette', then display the corresponding task here.

    To clarify my question, I have entered some pictures how I would like it and how the information is arranged.

    It would be really great if someone can help me with this,

    Thanks in advance!

    Merette
    Attached Files Attached Files
    Last edited by Merette; 11-03-2022 at 08:24 AM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Combine information from different tabs

    read big yellow banner at the top of this page

  3. #3
    Registered User
    Join Date
    11-03-2022
    Location
    Netherlands, Eindhoven
    MS-Off Ver
    2018
    Posts
    4

    Re: Combine information from different tabs

    Hi Sandy,

    Sorry, I have no clue how i missed that.
    I changed it immediately to an excel document.

    Hope you can help me solve this challenge,

    Kind regards,
    Merette

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Combine information from different tabs

    i don't understand your logic

    your expected result is not representative

    try create an example without long comments, you can make description in the post(s)

  5. #5
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,342

    Re: Combine information from different tabs

    Hi Merette,

    Which Microsoft Office version are you using exactly? 2018 is something different.
    Recent versions are 2019, 365 and 2021. (Click in Excel on your account name at the top right and then on Office user info)

    Hans (also from Eindhoven )
    Attached Images Attached Images
    Last edited by HansDouwe; 11-03-2022 at 08:59 AM.

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Combine information from different tabs

    maybe like this
    Attached Files Attached Files
    Last edited by sandy666; 11-03-2022 at 09:18 AM.

  7. #7
    Registered User
    Join Date
    11-03-2022
    Location
    Netherlands, Eindhoven
    MS-Off Ver
    2018
    Posts
    4

    Re: Combine information from different tabs

    Hi Hans and Sandy,

    Hans; I am using the license of 2016.
    Sandy; thank you so much for making this table, this is exactly the type of solution I was looking for!

    Thank you guys for taking the time to help me,

    Kind regards,
    Merette

  8. #8
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Combine information from different tabs

    you are welcome
    have a nice day

  9. #9
    Registered User
    Join Date
    11-03-2022
    Location
    Netherlands, Eindhoven
    MS-Off Ver
    2018
    Posts
    4

    Re: Combine information from different tabs

    Hi Sandy,

    How did you manage to combine the different tabs in one pivot table?
    I tried everything but I have no clue how to recreate your tables for my own project.

    Kind regards,
    Merette

  10. #10
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Combine information from different tabs

    update your profile first, XL2018 doesn't exist

    as you can see I changed your source data to Excel Tables (Ctrl+T) then load to Power Query Editor
    Next these tables are appended into one
    then close&load as connection
    on the end Insert - Pivot Table with feature:
    ptpq.png

+ 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] using a location reference, combine information from two tabs into a consolidated list
    By sgetraer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-07-2022, 08:10 PM
  2. combine excel tabs
    By swwell in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-30-2019, 05:47 PM
  3. combine excel tabs
    By swwell in forum Excel General
    Replies: 6
    Last Post: 05-30-2019, 01:29 PM
  4. SOLVED Combine all tabs
    By PC41 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-05-2019, 01:17 PM
  5. Creating TABS from a list and have these tabs have information populate automatically
    By clpickett3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2016, 03:35 AM
  6. How Do I split a file into several Tabs, acording to information on other tabs?
    By Edinson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2013, 05:17 AM
  7. Replies: 2
    Last Post: 09-05-2012, 08:54 AM

Tags for this Thread

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