Pivot table (dis)connections

Bostjan ISE

New Member
Joined
Dec 15, 2020
Messages
2
Office Version
  1. 2019
Platform
  1. 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:
1608022505600.png

Best regards

B.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,213,530
Messages
6,114,163
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top