leatherhen99
New Member
- Joined
- Dec 17, 2019
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
Happy Friday All!!!
I'm looking to take a canned report and create a quick timesheet that does all the calculations for me. The system is what it is (we just installed it), so I have to make lemonade out of the lemons that I have...and I'm at a loss in how to simplify the report. As a side note, I'm not the end-user, so it has to be something that will get them what they need with zero intervention from the end-user...other than to input the information into our timekeeping system.
A report generates into an excel report, and I've create formulas to get the information into a pretty table so that it calculates for the timekeepers - instead of having to do math based on what they're seeing.
An agent's daily time can fit into 3 categories... all REG time, all DIFF time or time can be part REG and part DIFF in the same segment. The following is one day for one employee...
I have multiple row criteria, and I can't even get it to pull the way that i need it to... if it has to be two columns, this is the way that i need it to look...
I would like to pivot this into one column so that DIFF and REG are in one date column...instead of two... The only option that i can think of, is to filter the DIFF column, make a copy of it, identify the new rows in the D column, and add that to the pivot table so they are all in the same column. This is a mockup, but this is how I want it to look... right now, i'm creating two different pivot tables, and then merging them into another tab...
Is there another option that I'm missing?
If there's an easy way to do it with VBA, I'm up for it so that it's automated.
Thanks!!!
Heather
I'm looking to take a canned report and create a quick timesheet that does all the calculations for me. The system is what it is (we just installed it), so I have to make lemonade out of the lemons that I have...and I'm at a loss in how to simplify the report. As a side note, I'm not the end-user, so it has to be something that will get them what they need with zero intervention from the end-user...other than to input the information into our timekeeping system.
A report generates into an excel report, and I've create formulas to get the information into a pretty table so that it calculates for the timekeepers - instead of having to do math based on what they're seeing.
An agent's daily time can fit into 3 categories... all REG time, all DIFF time or time can be part REG and part DIFF in the same segment. The following is one day for one employee...
I have multiple row criteria, and I can't even get it to pull the way that i need it to... if it has to be two columns, this is the way that i need it to look...
I would like to pivot this into one column so that DIFF and REG are in one date column...instead of two... The only option that i can think of, is to filter the DIFF column, make a copy of it, identify the new rows in the D column, and add that to the pivot table so they are all in the same column. This is a mockup, but this is how I want it to look... right now, i'm creating two different pivot tables, and then merging them into another tab...
Is there another option that I'm missing?
If there's an easy way to do it with VBA, I'm up for it so that it's automated.
Thanks!!!
Heather