Create an Excel file using a macro

C

Cillian

Hi,

I have a tempalte file to which some data needs to be entered. The data
comes in a big list of about 200 rows, with five columns - so five cells have
to be copied from each row into the template and saved seperately.

What I would like to do is to create a macro that will copy the cells from
each row into the template and save the template with the file name equal to
the value of the first two cells.

Can any one help?
 
Top