If number in Column A matches number in column B - Copy B cell and adjacent cells ?

[BPSJACK]

Hi,

I'm trying to update a macro I'm currently using but I need to expand a little further. Below is what I am trying to achieve:

Ref #1	Ref #1a	Ref #2	Qty.	REF#1a	REF#2	Qty.
TEST0000001	TEST0000007	123	1	TEST0000004	127	1
TEST0000002	TEST0000009	123	1
TEST0000003	TEST0000011	124	1
TEST0000004	TEST0000019	127	2
TEST0000005	TEST0000004	127	1

Basically, if a number in Column A (REF#1) matches a number in Column B (Ref#1a) I'd the macro to copy REF#1a and the adjacent cells to the right and paste them in a new column.

Does anyone know how I might go about this because I'm absolutely stuck :s

Jack