Match Column B data in Sheet2 with Column A in Sheet1, if not found/match then paste in last cell of Column A in Sheet1

[NileshAPatel]

Hi,

Please help to write VBA code for :

Sheet1 - Column A from Row 5 to10 has - 1,2,3,4,5
Sheet2 - Column B from Row 2 to 10 has - 1,2,3,4,5,6,7,8,9,

Needs to copy Sheet2 Column B data which are not in Sheet1 Column A and paste it in Sheet1 Column A after 5


Thanks & Regards
Nilesh Patel