Update Duplicate records - macro

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.

Apology for the late response but I can not get the above solution (code) to work as it keeps crashing on larger instances of data such as more than 40,000 and the code does not update the missing blanks but instead it erases data in column C.

I have attached workbook with he example of input, desired output and what the code is currently displaying.

Update_records_version2.xlsm

I am using the following code below:

Please Login or Register  to view this content.

Any help with this matter would be very much appreciated.