Forum Discussion
How to create a report based on a dynamic list of sheets?
Thanks for the response mathetes,
Sadly, I do not have access/permissions to the source DB and am stuck consuming the reports as they are exported.
One of your opening sentences, in your first post, was this "When I export this list from our system, it places each individual's information in their own sheet within excel," which suggests you at the very least have access to run this set of reports, and (implicitly) access to the data that is involved.
So I'll grant that you may not have the kind of master access that I had as the overall DB director, but I was able to grant views to divisional or location HR professionals to certain views of data they needed. It sounds like you do have that kind of access, albeit somewhat limited.
Based on what you've said, I'd encourage you to go to whoever it is that manages the whole system to see if you could be granted some kind of export of this very same data, just in a different format that would enable the kind of summary you're looking for. It would be a lot easier (and, importantly, less error prone) than reconstructing the raw data from the individual and variable sheets.
It's a submit form. I select the dates, click generate report and it comes back as HTML pages. There is an export button that I can click that then exports each of these pages to an excel document with all the sheets. That's my limited access to the data, no way to interface directly with the data outside of the form they provide. The "system" being the time reporting application provided.
OK, since it appears we're stuck with what you get, let me ask if you could post a couple representative samples (devoid of any actual names, SSNs,, etc., of real people) so that we could see if we can come up with a creative solution.
Use examples that illustrate the range of rows, different data, and make sure it's clear which data you need to extract and summarize.
And please include information on which version of Excel you're working with. The most recent updates to the Microsoft 365 subscription versions have some functions that might come in handy.....