Hi Johnno,
I noticed that your file structure is slightly different from the original file. I added Column 'V' in the 'Master' to indicate when the data was put in the subordinate workbooks (column 'U' was used for the files in your original post'. I only put data in the subordinate workbooks for the same columns that were used in your original post. If this is a problem, let me know what needs adding if you can't do it yourself. This is the code where columns can be added or deleted as needed:
Complete Code follows (less helper functions). See the attached .bas file in the zip fie for the complete code that can be imported into your file.
Lewis
Bookmarks