Find similar lines and combine
 

Sami,

Did you find a solution for this with a macro? I am trying to do basically
the same thing.

Thanks,

Scott

"Sami82" wrote:


Hi All,
I am writing a smaller part of a large macro and i need it to find
similar lines within the table and combine the totals. The first 5
columns need to be the same to combine the rows, for example:

A B C D
E F
Name Code Start Finish Amount
Total

PersonA PERA 01/10/2005 10/10/2005 $100.00 $3542.25
PersonA PERA 01/10/2005 10/10/2005 $100.00 $5487.50
PersonA PERB 22/09/2005 30/09/2005 $2451.00 $2547.78
PersonA PERA 01/10/2005 10/10/2005 $24.00 $1542.00

As above, the first two lines would be replaced with a singular row,
and the bottom rows would stay the same.

PersonA PERA 01/10/2005 10/10/2005 $100.00 $9029.75
PersonA PERB 22/09/2005 30/09/2005 $2451.00 $2547.78
PersonA PERA 01/10/2005 10/10/2005 $24.00 $1542.00

If anyone can help me with this i would be extremely happy!

Thank you!!


--
Sami82
------------------------------------------------------------------------
Sami82's Profile: http://www.excelforum.com/member.php...o&userid=27111
View this thread: http://www.excelforum.com/showthread...hreadid=491307

Find similar lines and combine
 

I found the best success with the post that Dave Peterson put through.
It takes a while to set up but once its done it works like a treat.
(thanks Dave)


--
Sami82
------------------------------------------------------------------------
Sami82's Profile: http://www.excelforum.com/member.php...o&userid=27111
View this thread: http://www.excelforum.com/showthread...hreadid=491307