Bostjan ISE
New Member
- Joined
- Dec 15, 2020
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
Hey there,
I am not really getting anything done with this one. The basic idea is to have multiple identical worksheets (each for a different person). On such a worksheet there is a table on the left, that you would input your data into, regarding worktime. To the right of this table, there should be a pivot table that summarizes the data from the table on the left (counting workhours, leaves, sickdays etc.). Everything pretty straight forward. Well up untill you decide to multiply such a worksheet, because the Pivot on the new worksheeet ist stil connected to the data on the source worksheet. If you "get new data source", things get messy pretty quickly since we are dealing with time values and custom formatting etc. Can the disconnection from the source data be achieved automatically, or can anything be done so that each new worksheet is an entity on its own.
The other idea is to somehow connect the data from the pivot tables (on these worksheets) to one main worksheet (dashboard). But I think thats more PowerBi territory, or?
Here a picture:
Best regards
B.
I am not really getting anything done with this one. The basic idea is to have multiple identical worksheets (each for a different person). On such a worksheet there is a table on the left, that you would input your data into, regarding worktime. To the right of this table, there should be a pivot table that summarizes the data from the table on the left (counting workhours, leaves, sickdays etc.). Everything pretty straight forward. Well up untill you decide to multiply such a worksheet, because the Pivot on the new worksheeet ist stil connected to the data on the source worksheet. If you "get new data source", things get messy pretty quickly since we are dealing with time values and custom formatting etc. Can the disconnection from the source data be achieved automatically, or can anything be done so that each new worksheet is an entity on its own.
The other idea is to somehow connect the data from the pivot tables (on these worksheets) to one main worksheet (dashboard). But I think thats more PowerBi territory, or?
Here a picture:
Best regards
B.