Quote Originally Posted by Aussiebear View Post
Welcome to VBAX Ruede. I notice that you have suggested that the new workbooks are to be based, on the first active column of the template, but the code is suggesting that you are using Column 2. Is this a typo?
Not a typo - just an inadequate explanation on my part

Over time, new entries are going to be added to the first column.
However, because the Excel user interface forbids worksheet names longer than 31 characters, I added a formula to the second column to restrict the length to 31. This is why the VBA code looks here for the names for the worksheets.