Create separate account statements from each row of account data

[mmoore5553]

I need to automate having a list of users and adding certain verbiage and taking in the variable names. I was going to use mail merge but i need it to stay in excel sheets

if you look at the code it just has a heading and then some words with the variables dropped in. I have added a result page on how i want it to look. Where the data is does not matter so much. Just trying to automate this. If there is an easier way that I am missing then let me know.

I am new to scripting and trying my best.

[Logit]

.
Understand that you know what you are working with .. the source and the destination of the data.

It is good that you provided a workbook ... HOWEVER ... your "Before" and "After" sheets don't match.
The actual data is different on both sheets.

Please provide data on both sheets that matches one another. When the names and dollar values match, we will have a much better idea where things go.

Thanks.

[mmoore5553]

I have updated the file. Sorry for that . I did not know how to put the children. If you have the children then it should put them. If you do not have children in the slot then it should show nothing. Usually they are in order but at times they are not. I hope that makes sense.

[6StringJazzer]

The data is consistent on both sheets. The idea is that there should be a sheet created for each row of data on Sheet1, which shows the names of the children and total paid. The example given in Result is for the "matt" children. There is no example result for the "lisa" children.

Edit: I see that the update to the file happened after Logit's post so maybe the consistency issue was fixed.

[mmoore5553]

yes that is correct. It should go to x amount of rows in the A column and have that person name with how much they paid and children. Then go to next row and make another tab with the same information.

[Mumps1]

Try:

Please Login or Register  to view this content.

There is no Business Name on Sheet1 so I could not enter it in cell A18 on the newly created sheets.

[6StringJazzer]

Please note that I updated to your title to something more specific.

[mmoore5553]

Mumps

that is great. I have to learn to read some of the code because i am not familiar with it. There is one slight flaw. if you run the script it takes the children and puts the correct one but anything after Matt has spaces. Lisa goes down the number of kids that matt has and then if you add another person then it skips down the amount that lisa kids had. I am not sure which variable needs to be reset.

this saves me a lot of time. Thank you so much. Now if i can figure this out .

[Mumps1]

Insert this line of code:

Please Login or Register  to view this content.

directly below this line:

Please Login or Register  to view this content.

[mmoore5553]

Mumps1 - you sir are a rock star. Now i am going back and learning what some of the syntax means. You have saved me tons of time. Thank you again.

[Mumps1]

You are very welcome.

[mmoore5553]

I need help again all. I had to change the format because they changed how they were getting the forms. Everything worked great until someone has 7 kids. I can not figure out how to get all of the kids to show up. If you look at adams2 ...you will see matt1 is missing. All the others matts are listed.

I can not figure out why the first one is not showing up. I understand almost all the code but i guess something is missing.

[Mumps1]

Try:

Please Login or Register  to view this content.

[mmoore5553]

mumps1 - you sir are brilliant.

Works great. I did not think of the range to be A. I tried all kinds of stuff last night. Thank you again. I need to find videos on how to get training to get the knowledge.

[Mumps1]

My pleasure.