Hi All
I have tried Shg's code and I've hit a problem in that the code stops at Set wksFr = Workbooks("thisWorkbook").Sheets("thisSheet")
This workbook is a variable name although the worksheet will always be the same name. If I hard code it to be the name of the workbook that I am working on then it works until I want to switch back to the source data workbook where it doesn't switch back (probably because my code is incorrect)
I've added my code below so perhaps you can see where I'm going wrong.
Thanks for all your help and apologies if I have broken any protocols.
Regards
John
Bookmarks