• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy Column cell values from one Workbook sheet to another Workbook sheet


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.


Marc L

Excel Ninja

As like on any forum the cross post link must be in the thread …
So please here and on each other forum !​