Hi all,

I am new to vba.
I need vba for following.
A & B column contains data. Each row in both column has one common number in either A column or B column.
I want to copy that number.

Example

A B
11 56

73 11

97 11

11 39

In above, 11 is common number. I want that number to be copied.
Please help.

Thanks in Advance