Hi,

I am new to VBA but I know how useful it could be, what I have is several
spreadsheets full of names and other data like -

Name City User ID

I want to be able to loop through these names, create a new sheet in an new
file, using a template from another file and fill in the details on the
template (i.e. name, city). So i end up with a new file with a sheet for
every user....

Can anybody give me any tips on where to start??

http://www.rondebruin.nl/copy5.htm

--
regards,
Tom Ogilvy

"westg" <(E-Mail Removed)> wrote in message
news:E14CD929-6D30-44B6-A445-(E-Mail Removed)...
> Hi,
>
> I am new to VBA but I know how useful it could be, what I have is several
> spreadsheets full of names and other data like -
>
> Name City User ID
>
> I want to be able to loop through these names, create a new sheet in an
> new
> file, using a template from another file and fill in the details on the
> template (i.e. name, city). So i end up with a new file with a sheet for
> every user....
>
> Can anybody give me any tips on where to start??