Hi,

Could someone please help.
I've got 2 columns: A & B as per below.
I want to write a macro so that if the data in column A matches col B
then put them in the same line.
A B
Row 1 QQQQ SSSS
Row 2 WWW QQQQ
Row 3 EEEE UUUUU
Row 4 RRRR EEEEE
In this case A1 is the same as B2. I want to insert a row in Column A
so that in looks like the below. This will go on for each row.
A B
Row 1 SSSS
Row 2 QQQQ QQQQ
Row 3 WWW UUUUU
Row 4 EEEE EEEEE