I need some help trying to figure out how to do the following:
I have coded some vba script and havent figured out the most efficient way of getting a solution. The code seems to be partial working but instead of subtotaling each block of data it keeps the previous balance and adds it t the next block.
There are two tables in my sheet,
-Table1 Represents days in which hours were present with 1's.
-Table 2 is the actual Hours logged by the individual.
My goal is to apply a dollar amount only once per day following the next criteria:
1) Subtotal each day data block in Table 1 (Having Issues with, i dont seem to be understanding the examples that lead to my code)
2) once each block is subtotaled, if the number is greater than 1, i know there is more than one time entry on that day. i would use the second table to determine which day item logged the most hours. The item with the most hour would remain while the other 1s on that day would be zeroed out. (not yet coded)
this would allow to only apply the dollar amount once per day to the biggest time entry event.
Im attaching my test file for reference.
Any help in getting the code to work or implementing a different solution would be appreciated. This needs to be in vba as i will further add more parts for a automated process.
Bookmarks