Hi Admin,

Thanks for your quick reply. This code solved my other issue
However, i am still struggling with my current issue. This code Autofill the same value i have in other row. But i am looking to autofill the value I have in target row.

The attached file will clarify it.

Autofill.xlsx

Thanks in advance

Rajesh