Hi Sir, I am intermediate learner of vba and stuck in problem. Copying the column value from one Workbook sheet to another workbook sheet. There is column named Sort Reference in Workbook1 and that column contains numbers till 250 and these cells values to be pasted in another column Notes And Assumptions in Workbook2 but in Workbook2 has only 10 rows which has values and I need only 10 cell values to pasted from Sort Reference to Notes And Assumptions. I have provided the files attached with post and also code in module1. I have also attached the Result workbook where in column Notes And Assumptions i.e; like this the data I needed. Thanks in advance.