A
Andy
Hi,
Can anyone tell me how I use VBA to compare rows to each
other and if the previous row is different to the current
row then insert a line and sum the total of the row that
are equal?
This is really driving me mad. I have tried using the
Sumtotals option in the data menu in excel but I want to
compare rows using two or more cells in a row. ie coparing
by column b then by coulmn a and summing column c.
Can this be done is VBA?
Any help would be great thanks
Andy
Can anyone tell me how I use VBA to compare rows to each
other and if the previous row is different to the current
row then insert a line and sum the total of the row that
are equal?
This is really driving me mad. I have tried using the
Sumtotals option in the data menu in excel but I want to
compare rows using two or more cells in a row. ie coparing
by column b then by coulmn a and summing column c.
Can this be done is VBA?
Any help would be great thanks
Andy