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

- - Latest reply: ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
- May 7, 2019 at 05:25 PM
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
See more 

2 replies

Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1568
0
Thank you
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.
Respond to ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1568
0
Thank you
You really need a database, not a spreadsheet.
Respond to ac3mark