Forum Discussion

Carissa_aggie's avatar
Carissa_aggie
Copper Contributor
Feb 19, 2020

Populate summary page in Excel

I am creating a contact list with a summary tab, then a separate tab for each contact. How do I get the information from each tab to pull to the summary tab without having to link every cell individually?  Each contact tab is identical with information pulling into 5 separate rows on the summary tab with multiple columns in each row.

Example of Summary Tab:

Example of Contact tab:

 

Charting
excel
Formulas and Functions

1 Reply

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Feb 20, 2020

    Hi Carissa_aggie 

     

    I think you should do it other way, create a master list, give each row a record number (unique no/serial no) then you can use XLOOKUP or VLOOKUP taking that record number to pull the information from the mastersheet to contact tab as per your need just by changing the record number. Once you have master list you can play with data as you like it.

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com

Resources