+ Reply to Thread
Results 1 to 15 of 15

Create separate account statements from each row of account data

  1. #1
    Registered User
    Join Date
    03-15-2019
    Location
    kentucky
    MS-Off Ver
    365
    Posts
    7

    Create separate account statements from each row of account data

    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.
    Attached Files Attached Files
    Last edited by 6StringJazzer; 11-17-2019 at 12:11 PM. Reason: Moderator updated title for new user

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,532

    Re: Help to automate excel spreadsheet -

    .
    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.

  3. #3
    Registered User
    Join Date
    03-15-2019
    Location
    kentucky
    MS-Off Ver
    365
    Posts
    7

    Re: Help to automate excel spreadsheet -

    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.

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,206

    Re: Help to automate excel spreadsheet -

    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.
    Last edited by 6StringJazzer; 11-16-2019 at 11:49 PM.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  5. #5
    Registered User
    Join Date
    03-15-2019
    Location
    kentucky
    MS-Off Ver
    365
    Posts
    7

    Re: Help to automate excel spreadsheet -

    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.

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5,812

    Re: Help to automate excel spreadsheet -

    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.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  7. #7
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,206

    Re: Create separate account statements from each row of account data

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

  8. #8
    Registered User
    Join Date
    03-15-2019
    Location
    kentucky
    MS-Off Ver
    365
    Posts
    7

    Re: Create separate account statements from each row of account data

    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 .

  9. #9
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5,812

    Re: Create separate account statements from each row of account data

    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.

  10. #10
    Registered User
    Join Date
    03-15-2019
    Location
    kentucky
    MS-Off Ver
    365
    Posts
    7

    Re: Create separate account statements from each row of account data

    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.

  11. #11
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5,812

    Re: Create separate account statements from each row of account data

    You are very welcome.

  12. #12
    Registered User
    Join Date
    03-15-2019
    Location
    kentucky
    MS-Off Ver
    365
    Posts
    7

    Re: Create separate account statements from each row of account data

    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.
    Attached Files Attached Files

  13. #13
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5,812

    Re: Create separate account statements from each row of account data

    Try:
    Please Login or Register  to view this content.

  14. #14
    Registered User
    Join Date
    03-15-2019
    Location
    kentucky
    MS-Off Ver
    365
    Posts
    7

    Re: Create separate account statements from each row of account data

    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.

  15. #15
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5,812

    Re: Create separate account statements from each row of account data

    My pleasure.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA - Automate counting ranges in excel spreadsheet
    By liwi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-29-2018, 04:18 PM
  2. Automate Macro When Opening Excel Spreadsheet
    By nate5539 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-30-2018, 12:21 PM
  3. [SOLVED] Automate Spreadsheet
    By MechEst in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2015, 03:20 PM
  4. Replies: 6
    Last Post: 09-27-2012, 10:45 AM
  5. How to Automate a SpreadSheet?
    By davey11372 in forum Excel General
    Replies: 3
    Last Post: 02-14-2010, 03:04 PM
  6. Automate Spreadsheet
    By Karen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-03-2006, 02:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1