Forum Discussion
How to create a report based on a dynamic list of sheets?
I have a list of individual reports, hour reports of employees. When I export this list from our system, it places each individual's information in their own sheet within excel. I'm trying to use eac...
I need to pull the hours for each individual and show a row per person with their hours. I wish I only needed a SUM of them all 🙂 I have an ever-changing list of sheets and need to turn data from each sheet into a single row on 1 master sheet for ease of viewing, and ideally have that master list change based on the number of sheets exported. Hope that helps clarify my problem and thanks for the response!
AustinAdams , can you upload a sample with a few sheets (making sure that all confidential information is removed)?