Dear Colleagues Globally,
I am seeking assistance in establishing a Power Query for analyzing timesheets within my team. Each week, I receive timesheets for various projects, each stored in separate worksheets. As the year progresses, new projects may emerge, necessitating the creation of additional worksheets.
My objective is to streamline this process through an effective Power Query setup. These timesheets are emailed to me monthly.
If anyone has expertise in this area or can offer guidance, your help would be greatly valued. I am open to further discussions, including arranging a call if necessary.
Your support in this matter is much appreciated.
Thank you
I wonder why you would capture time in separate sheets per project. It would be more effective to receive weekly timesheets from employees that contain all time spent that week. Save all timesheets in one folder and connect to "Files from Folder" with PQ.
Then, in PQ all timesheets are combined into one big table with time recording information that can be grouped by Project, employee, time period etc. or any thinkable combination of these. Whatever may be relevant to report on.
Now, it requires a bit of work to get it properly set-up, but once you have done it right, it's no more than receiving time sheets, saving them in the designated folder and refresh the query(ies).
Perhaps the video in the blog posts below will get you going.
https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder
