Good day folks,
I was wondering if someone could help me with a function that will sum up hours based on a employees timecard. It is kind of a unique setup but I think someone may have come across a similar problem. Here is the setup, I have a Raw data tab that contains:
EEID EE Name HrsWorked Rate
1 Name1 3 10
1 Name1 3 10
1 Name1 8 15
2 Name2 3 15
2 Name2 3 15
2 Name2 8 15
2 Name2 6 15
2 Name2 4 15
3 Name3 1 14
3 Name3 9 14
3 Name3 8 18
3 Name3 8 18
3 Name3 7 18
Then I have a main tab that sums up each employee based on there "Rate". The calc is this HrsWorked * Rate. But the catch is this, if the employee's rate changes this that will afect the line item on the main tab. The main tab looks like:
EE ID EE Name HrsWorked Rate Fees
1 Name1 6 10 60
2 Name1 8 15 120
3 Name2 24 15 360
2 Name3 10 14 140
2 Name3 23 18 414
I understand the VBA part on bringing over the name, but I cannot understand how to separte this data by rate? Essentically, I want to take the data from the Raw tab and transfer it over the main tab, and at the same time rolling up the data, based on the Rate. Keeping in mind that the Rate may or may not change during the time frame. If anyone could help me on this it would be great.
Thank you,
I was wondering if someone could help me with a function that will sum up hours based on a employees timecard. It is kind of a unique setup but I think someone may have come across a similar problem. Here is the setup, I have a Raw data tab that contains:
EEID EE Name HrsWorked Rate
1 Name1 3 10
1 Name1 3 10
1 Name1 8 15
2 Name2 3 15
2 Name2 3 15
2 Name2 8 15
2 Name2 6 15
2 Name2 4 15
3 Name3 1 14
3 Name3 9 14
3 Name3 8 18
3 Name3 8 18
3 Name3 7 18
Then I have a main tab that sums up each employee based on there "Rate". The calc is this HrsWorked * Rate. But the catch is this, if the employee's rate changes this that will afect the line item on the main tab. The main tab looks like:
EE ID EE Name HrsWorked Rate Fees
1 Name1 6 10 60
2 Name1 8 15 120
3 Name2 24 15 360
2 Name3 10 14 140
2 Name3 23 18 414
I understand the VBA part on bringing over the name, but I cannot understand how to separte this data by rate? Essentically, I want to take the data from the Raw tab and transfer it over the main tab, and at the same time rolling up the data, based on the Rate. Keeping in mind that the Rate may or may not change during the time frame. If anyone could help me on this it would be great.
Thank you,