Hi KaitMacN
Yes - exactly right.
Assuming the second workbook is called "Book2" with the same named worksheet it would look like: 
Set ws2 = Workbooks("Book2").Worksheets("Sample data")
I believe both workbooks need to be open.
BTW thanks for the feedback.
Barry