Forum Discussion
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 individu...
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