Save multiple files using contents of a column

[Bien1986]

Hello,

I’m not certain how to word this, but here is my attempt:

I have a template in an excel worksheet that needs to be saved using a thousand plus plan names which are listed in another excel sheet under column c.

basically i want to run a macro that will pull the name out of column c (on the list worksheet) and repeatedly save the template file using the plan names listed in column c on the (list worksheet). So once all is complete, there will be a thousand plus files saved in a folder that will all have the template on them.

any advice on how to write a code to do that? (I’m using the developer tab/vba in excel)

-I’m very new to creating macros, so far i've only recorded macros, never written. (i've tweaked per book instructions and I’m still learning language etc). I think I need to add something called a loop to the macro text.

[jolivanes]

Try this

Please Login or Register  to view this content.

It assumes the names start in C1 and you want them saved in the same directory as your active sheet with the names.
However, I don't know if you want to save them as .xls so you probably need to change that.

Regards
John

I just read that it is in different workbooks. Only works from this workbook.