I need a macro that will total numbers from duplicate entries and move the totals to new cells. As you can see on the attached sample the name "Albright" has two lines of amounts. I would need the total of F2 and F3 placed in I2, it would also have to total and move G2 and G3, H2 and H3 to J2 and K2 respectively. I would have to run the macro manually as I have 3500 lines with these double entries stuck in at different places. My active cell in this instance would be A2 I would run the macro it would do the calculations, move the totals then delete the duplicate row. I have made other macros to move and delete rows but never had one with a formula in it. Thanks for all the help.
Bookmarks