I've got a two sheet workbook.
Sheet 1 has a PivotTable linked to a database.
Sheet 2 is blank.
I programatically move through the pivottable drop-down filter which cause the pivottable to recalculate. I then copy and paste those values to sheet 1. I then move onto the next value in the pivot...
Hi ,
I've got a database of staff clock-in / clock out times. What I want to do is report on the number of staff in work each hour of the day. If a person is in more than 35 minutes out of the hour then they are regarded as being in for that whole hour.
Database example;
Fields...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.