I am trying to come up with a solution to a project for work. Basically the system is to store daily management information and be able to analyse the data.
What I need is a sheet for every day of the year for several managers to fill in.
I then need a master sheet that will pull all of the data from the tables in these daily sheets in to a master table that can be analysed.
The idea I had was to have a workbook for each month for the managers which would have a sheet/table for each day of the month.
Then in the master sheet load all of this data in so it can be converted to a pivot table to be analysed.
Heres a picture of what the daily table would look like. The master table would also be the same but it would just have all of the rows from the daily sheets:
Can anyone think of a better way of doing this?
What I need is a sheet for every day of the year for several managers to fill in.
I then need a master sheet that will pull all of the data from the tables in these daily sheets in to a master table that can be analysed.
The idea I had was to have a workbook for each month for the managers which would have a sheet/table for each day of the month.
Then in the master sheet load all of this data in so it can be converted to a pivot table to be analysed.
Heres a picture of what the daily table would look like. The master table would also be the same but it would just have all of the rows from the daily sheets:
Can anyone think of a better way of doing this?
Last edited:
