Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Need Macro Created For Me

-1

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

Answer
Discuss

Discussion

In the forum you can get specific help on the macro; but, if you want one created like this for you from scratch, you should use the contact link at the top of the page and will be charged a fee for it. The alternative is that you can work on it yourself and when you get stuck as that specific question, ask it here in the forum.
don (rep: 1989) Mar 27, '18 at 4:08 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login