Save template using list of filenames

[co]

Hello all,

I have a one sheet template which I need to save as 200 new separate files.
On a separate spreadsheet I have a list of the 200 cost centres they need to be saved as.

Is there a macro to automatically saveas and rename the tab for each one to avoid me doing this manually?

Many thanks in advance,

co

 

[P Sitaram]

Another obvious question - Is the macro posted in `ThisWorkbook' module of the Template workbook?

 

[co]

Yes.

I've also tried with two new blank spreadsheets (except for some data in A1:A200). But in just comes up with the same error.

co

 

[P Sitaram]

Well, i replicated all the names etc. and i now have a directory of 200 files!

Hope your code does not have `costcenters' for 'costcentres'. Other than that, i really don't know what to suggest.