TABLE:
IGNORE OK REVERSE
BLANK Cost1 Cost2 Cost3
CC ID TEXT Cost1 Cost2 Cost3
1100 0000278 xxxx 100 5000 1000
1100 0001006 xxxx 100 5000 1000
2710 0001083 xxxx 100 1000
2710 0001170 xxxx 100 5000 1000
8400 0001228 xxxx 100 5000 1000

If you copy the above table into a worksheet called 'SOURCE' and create a
second called 'JOURNAL' & then copy the macro into the workbook and run you
should get the below table.

BASIC PAY 1100 5,000.00
BASIC PAY 1100 5,000.00
BASIC PAY 2710 5,000.00
BASIC PAY 8400 5,000.00
OVERTIME 2.0 1100 1,000.00
OVERTIME 2.0 1100 1,000.00
OVERTIME 2.0 2710 1,000.00
OVERTIME 2.0 2710 1,000.00
OVERTIME 2.0 8,400.00 1,000.00

However I would like to adjust the macro so that any matching Cost1 & Cost2
lines create 1 single line and not two. - The end table should look like this.

BASIC PAY 1100 10,000.00
BASIC PAY 2710 5,000.00
BASIC PAY 8400 5,000.00
OVERTIME 2.0 1100 2,000.00
OVERTIME 2.0 2710 2,000.00
OVERTIME 2.0 8400 1,000.00

The data above is only an extract and consists of more rows & columns (there
could be any number of same Cost1 & Cost2 in the list).

Many thanks in advance for any help possible.
Steve