Hello all,
I am looking to make 1000+ reports based on a template. I have other sheets referencing the target city to update the data they report on. I have a master macro that calls on three other macros to format accordingly and save as "Location Report- Austin 1".
After creating the Austin report, I am looking to make one based out of the Dallas location. Thus I change the Target City to that all the other sheets will automatically update and then run the three macros (format and save file). My question is, how can I loop my macro so that it works its way down the 1,000+ cities. I am wondering if I can combine a Do Until statement and embed the other three macros within it.
<tbody>
</tbody>
Thank you in advance and will greatly appreciate any guidance.
I am looking to make 1000+ reports based on a template. I have other sheets referencing the target city to update the data they report on. I have a master macro that calls on three other macros to format accordingly and save as "Location Report- Austin 1".
After creating the Austin report, I am looking to make one based out of the Dallas location. Thus I change the Target City to that all the other sheets will automatically update and then run the three macros (format and save file). My question is, how can I loop my macro so that it works its way down the 1,000+ cities. I am wondering if I can combine a Do Until statement and embed the other three macros within it.
City | # | Target | # |
Austin | 1 | Austin | 1 |
Dallas | 2 | ||
Houston | 3 | ||
Chicago | 4 | ||
Miami | 5 | ||
Phoenix | 6 | ||
... | ... | ||
... | ... |
<tbody>
</tbody>
Thank you in advance and will greatly appreciate any guidance.