Use a macro to create new exceel files based on a range of cells

Hi my name is Eugene,

I have a template which I would like to save as a new file based on text typed in a range of cells, I have found similar macros but I don't know to much about macros and can't alter them to suit my application,

In cell A1 to A100 of my master file I have a different part numbers entered as text, I would like a macro that looks at the contents of cell A1 and then create a new excel file in a location on my c drive (my documents) and then comes back and creates a 2nd new file that looks at the contents of cell A2 ..and repeats the process through to cell A100
So in other words I would have a 100 new files with different names that has the contents of the original file. However the new files need to exclude the contents of cell A1-A100,

Can anyone help with this?

Hi
a couple of questions
are the names of the new files the same as the cell contents in range a1:a100?
and, by "exclude", do you mean the new files have nothing in range A1:A100?

Hi

Yep, you're onto it