Here's the Macro I need..
Format all cells down to the 99th row and over to the "X" column to "Numbers" with 2 decimal places for example 15.37
When the values in column G are duplicates,
Total the values in columns E and F that are in the same rows as the duplicates in G
For Example:
If G1, G2, G3, and G4 are duplicates then H4 =sum(E1:E4) and I4=sum(F1:F4)
If G5, G6 G7 are duplicates then H7=sum(E5:E7) and I7=sum(F5:F7)
If G8, G9 are duplicates then H9=sum(E8:E9) and I9=sum(F8:F9)
If G10, G11, are duplicates then H11=sum(E10:E11) and I11=sum(F10:F11)
And so on and so on .
And last I need column "H" to be totaled at the bottom
And I need column "I" to be totaled at the bottom
Let me know if you can do this?
Thanks,
Jeff