Results 1 to 4 of 4

Thread: Help to automate excel spreadsheet

  1. #1
    Seeker mmoore5553's Avatar
    Join Date
    Mar 2019
    Posts
    15
    Articles
    0
    Excel Version
    office 365 excel

    Help to automate excel spreadsheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

    the results page should have the info that is provided and the script will go back and get the next user and then have her info in the spreadsheet. It should do that for x amount of people in A column.

    Below I have attached the document to review

    arraytest.xlsm
    Last edited by mmoore5553; 2019-11-17 at 08:49 AM.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,680
    Articles
    0
    Excel Version
    O365
    You don't need VBA, you can do it with formulas.

    In B16 add data validation, with a type of List, and a formula of
    =OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A:$A)-1,1)

    In B18, add a formula of
    =VLOOKUP(B16,Sheet1!A:G,7,FALSE)

    You can select the child from the DV list and print it off or whatever, then the next.

  3. #3
    Seeker mmoore5553's Avatar
    Join Date
    Mar 2019
    Posts
    15
    Articles
    0
    Excel Version
    office 365 excel
    unfortunately that will not work for me. I have tons of files that i will need to do this too. I will need something to loop through the person and then go to separate tabs. But thank you bob for that insight.

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,680
    Articles
    0
    Excel Version
    O365
    Why do you have lots of files that do the same thing? Why not amalgamate them and make it all more manageable?

Tags for this Thread

Posting Permissions

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