Need suggestions on what to use for a real time tracker which auto refreshes the data every hour.

[prodigal_nerd]

So, I have a SharePoint folder with excel files of my colleagues with their name on it, 10 excel files which they use to do audits daily. I need to create a tracker which tracks their daily audits completed and a progress tracker for the monthly target. So, tracker for daily completed audits and how close are they to completing the monthly target. Each colleague file has the same exact rows and columns because they do the same type of audits. And all have a Audit date column which they fill after completing an audit. And all 10 files have excel table filled with all the names of individual who's audits need to be completed for the month(i.e target for the month). What's the best way to create a real time progress tracker on a new excel file?

 

[Peter_SSs]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Need suggestions on what to use for a real time tracker which refreshes the data daily or hourly
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.