Hello,
I have a spreadsheet which has 4 Columns.
Column 1 - Title
Column 2 - Location
Column 3 - Ph Number
Column 4 - Quantity needed
I am looking to create a Macro that will look at the row, and then copy the row down {column 4} times. I am using this to create a Mail Merge with word, and manually do it now.
I am including a sample file, you will see "Test File" which would be my main file, and "Sample Results" is what I am trying to achieve.
Thanks in advance!
See if the attached workbook is acceptable.
See if the attached workbook is acceptable.
Hey Brian, That's pretty close. However, if you "Run It" and then modify the content..... Delete the "Results", "Run it" again... modify the content, Etc. It leaves many blank columns in the above rows on the "results" page. The file will change often, so if possible I'd like the results to be clean each time I run it.
I modified the code to do and End-Up from the used range row, which should solve the problem, but let me know if you need it to do something else.
Awesome, thanks for the help!!
I modified the code to do and End-Up from the used range row, which should solve the problem, but let me know if you need it to do something else.
Hey Brian,
I spoke to soon, I tried to add more of my data and it's still not running right.
As you can see in the attached file I have 8 rows this time, if you add column D the results should be 75 Rows, however it is 41 with a few blank rows at the top. Did you write the macro to be dynamic on the amount of rows, or hardcode it to be only 4 rows based on the sample? I could have as many as 100 rows depending on the project.
I redid how I was pasting the values. I also added code to clear the results before running and adds the titles to the Results sheet as well, so you don't have to do it manually.
Don’t have an account yet? Register yourself now and be a part of our community!
