mmoore5553
New member
- Joined
- Mar 8, 2019
- Messages
- 19
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- office 365 excel
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
View attachment arraytest.xlsm
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
View attachment arraytest.xlsm
Last edited: