buhay
09-23-2010, 01:09 PM
I am trying to add cells togehter containing the same text in the preceding columns.
For example
------colA------colB
row1---ABC-------7
row2---ABC-------5
row3---ABC-------2
row4---EFG-------10
row5---EFG-------15
row6---EFG-------5
is supposed to look like this after using the macro
------colA------colB
row1---ABC-------14
row2---EFG-------20
Any help is appreciated
For example
------colA------colB
row1---ABC-------7
row2---ABC-------5
row3---ABC-------2
row4---EFG-------10
row5---EFG-------15
row6---EFG-------5
is supposed to look like this after using the macro
------colA------colB
row1---ABC-------14
row2---EFG-------20
Any help is appreciated