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

MBEr - May 7, 2019 at 05:07 PM
 Blocked Profile - May 7, 2019 at 05:25 PM
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:

2 responses

Blocked Profile
May 7, 2019 at 05:24 PM
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.
Blocked Profile
May 7, 2019 at 05:25 PM
You really need a database, not a spreadsheet.