Hi!

I have a workbook, where there is a master data in Sheet 1.

I have to look up data from the Sheet 1 in Sheet 2.

Here the only issue is, I already have some data in Sheet 2 Column B which I need to keep, and should not be deleted.

I can do the same using Excel, however I want to know how to write a VBA code for the problem.

Sample sheet attached!

Can anyone guide me regarding the same?