I have a huge weekly data set called a 'activity sheet' that is inputted with numbers by several people per AM and PM shift
The front end is spread over 52 tabs so 52 weeks worth of activity data
I need to collate all this data into one master file which consists of breaking down per day per week per month per quarter and being able to build a dashboard from that data.
Struggling with the Data Table piece - is there anyone willing to collaborate with me on this and help further? I feel there are simpler ways to do this but not entirely sure.
Thanks
Bookmarks