Please help me connect my workbooks to a master excel worksheet. [Closed]

Report
-
 Blocked Profile -
Hello,
I have been through every excel video and forum trying to figure out how to connect my Excel workbooks for a tracker I have been working on. I have had no luck so far.
The tracker is used for a qualification and certain topics to complete the qualification. The master sheet is to see all the other three trackers but just the overall information, not all the topics. I just want the three sheets to talk to the master sheet so when new members are added to the company trackers they are added to the master tracker as well as their progress.

Please if anyone can help!!!! Thanks in advance

Here is the link to my folder: https://www.dropbox.com/sh/zjx6tl24fvzw1s8/AABi959n4_XtaPZllOdGrxt7a?dl=0

2 replies


So use the master as a dataset. Make a new connection into the sheet file, and pull what columns you want. excel has a wizard for data connections. Use it.

You really need a database, not a spreadsheet.