Hi,

I require a small help in creating a macro which can find duplicate records between column A to C and copy and paste into blanks of column C and B, only if column A has two empty columns B and C.

for example - input data
(A), (B), (C)
AW12,567
SW12,
DE34,
FR56, 45673
AW12 ,567, 678
DE34, 5677543

desired output:

AW12, 567
SW12,
DE34, 5677543
FR56, 45673
AW12,567, 678
DE34, 5677543

Any help would be very much appreciated. Thank you so much.