Loop runs over its last count in a code with error handling? (With example)

Wow! First of all, congratulations on using Excel Tables. You've certainly done your homework on how to address the parts of the table.

Your assessment on duplicating code is accurate. This is not necessarily a bad thing but it does make it more difficult to maintain. You may have to go to multiple parts of the code to fix a bug or change the code. You do have the potential to clean this up since you appear to be using a very consistent naming convention for regions and table names throughout.

I might be able to reverse engineer the code and figure out what is going on, but I believe that there is an entirely different way of doing this.

First, I'd like to know what the relationship between Table1 and Table2 is. I can see that they are using two runs to create the data.

We could use the information in Info&Admin and VLOOKUPS in Table1 and Table2 to pull the region in as "helper columns". Then we can run pivot tables against the table and loop through the filters by region. This will produce results by region one at a time. We can overlay the results of the pivot table with a named dynamic range and copy / paste that into the appropriate report section. It will still take programming, but Excel will be doing the bulk of the work and VBA would only be needed to sew things together.

Let me know if you are interested in this approach. In the process I'll show you a couple of "pointers" (at least that's what I call them).

Also, if it would not compromise anything, could you use real headers in Table1 and Table2? The rest of the data is sanitized enough.

I'm always willing to help out a fellow GI (USAF Retired).

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

You have been a member long enough to know about this requirement. Please read our rules before posting here again.