How I wish Excel had Mail Merge

Hi All, New to the forum so excuse any mistakes please

I have a little problem that would be easy to solve IF Excel had mail merge but as it doesn't I'm wondering if there is a Macro solution.

I need to create about 130 almost identical workbooks. Each one has about 10 cells that make it different from the rest, (name, etc) I have all these in a workbook one per row and a nice template to work with but I'm wondering if there is a method of automating the insertion of this information into the template and saving it as with the name as a file name? I could cut/paste each one but thats a long slow process and feel in my gut there must be a way to automate this.

Thanks in advance,
Chris

Where is the information that you're updating it with coming from?

Nevermind, just re-read your post, you have them in a separate worksheet, one per row...

Can you post example workbooks?

Wow that's a quick response! Not at the moment I cant because They are on my work PC and its officially the weekend now YAY! lol but basically there is a table set up in the template with cells for name, form group, and some grades. (these cells are not all sequential which probably doesn't help I know)
Then in the source sheet there is one row per student, (name,form,grade,grade.....etc) then next row the next student. Basically I need a copy of the template per student, saved under their name would be best.
I know I could enter the data manually and save then enter next one but such a repetitive job seems just made for a mail merge if only Excel had one
In case its not obvious I work in a school.
If it helps I know minimal Visual basic, enough that if I had a macro that did the insert name at a1, insert form group at b1 save template as name in a1 then onto the next source line until it ran out of source lines. I could adjust the macro to insert into the correct cells and copy/paste the insert code to insert the other bits. (Probably, Maybe. lol)

Basically we would take your list, create variables for Name, Group, etc. Then loop through each line, opening the template, updating the fields, then saving the template as a new file based on the data, rinse-repeat.

Can't give exact code without examples though...

I'll see what I can dig out monday thanks for the help

Here are the template and data files samples... Hope they help
Oh and these are Office 2010 files I just realized I use 2010 at work but put 2007 in info because that's what I use at home.

Hi all,
Just peeping in see if anyone has any ideas

Hi John,
To be honest I put them in to aid in clarity for anyone in the forum looking at the sample files....
The cell references can stay or go either is just as easy for me. In fact the headers can probably go too and just have the raw student data in them.
Obviously the data is sample data because I cannot publish actual student data I will be pulling the real data from a database that will export to an excel spreadsheet which I will then use as the data source but I can adjust that data file however works best.
Its one of those situations I instinctively felt would be ideal to automate otherwise I have about 130 sheets to copy manually and then copy/paste in the data which should be a breeze for a pc lol
It feels like it should be as easy as a mail merge which I've used often to produce final reports but alas Excel doesn't do mail merge lol
Thanks in advance

Chris

Whichever is easiest I'm happy with. My main goal is to have something usable. If I can actually understand how its working then that is a Bonus. I have basic VB understanding and have managed to modify some simple macros that almost did jobs I needed when I found them, For example, I found a script that took data from multiple workbooks and made a data sheet (kind of the opposite of what I need now) and understood it enough to modify it to collect data from more cell references than the original. But that's about the limit of my knowledge. I'm of an age where when we where growing up thats how you learned to program, take something that did a job and work out how it did it and modify it as you went along lol.
Thanks for all your support

Lol that would be awesome. As its about 4am here I should probably head off for some sleep myself.

Peeps in to see if jaslake or eg0e or anyone else for that matter has had any success
....
Wow that was odd.... Jaslake's response didnt show and I in fact had no notification he had even replied until I posted then suddenly there it was :D

Will give it a try at work on Monday but thanks in advance Jaslake

Hi John,
You are a star!
This macro works just as I needed.
Thank you so much.
Cheers,
Chris