Create multiple excel documents from rows in a sheet...

I have a workbook and in it are 2 sheets. The first sheet is a form and the second sheet is a list of user information (First Name, Last Name, Amount, Rate).

On sheet one I can fill in the first records information from sheet 2 with =+Sheet2!B2 for Last Name etc.

My question is I have 2k records on sheet 2 and I want to make a new excel document for each record on sheet 2.

For example I have record one is John Smith so I want to create an excel doc with his information, then record 2 is John Doe so create an excel doc with his information filled in.

Does this make sense? Is it possible?

Cross-Post: http://www.mrexcel.com/forum/excel-q...ows-sheet.html

I got this function:

Code:

Please Login or Register  to view this content.

So I tried this and does part of it.

When I run the macro it creates a new workbook and labels it with the info from Sheet2 for each person which is awesome.

But if I look at the file, it has the 4 fields I need to populate in my form on sheet1 of the workbook but they are just in a single row of the new workbook and the actual form I need is not there.

So get a workbook with something like:

John Doe 1 4

Then another workbook with:

John Smith 1 5

But that data isn't in the form that I am trying to populate on sheet1 of the same workbook where sheet2 data is located.

Sorry if I am not making sense.

Cross posted at http://www.mrexcel.com/forum/excel-q...ows-sheet.html

Murray,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

Also,

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

P.S. - These are 2 different sites so you need to post cross-posted links.