Hi rcm,
Thank you for your reply.
Actually I got this error:
Sub or function not defined on this line: ws2 = Workbook("chambersNJ.xlsx").Sheets("sheet1")
The destination column is not always the same. I use the number before FALSE to indicate on which one I want insert the values. In the example provided, destination column is B.
Bookmarks