Adjusting macro to loop through criteria

[rhudgins]

I would like to run the following macro in a loop for the five criteria listed in cells AE3:AG7. Right now it is only running the criteria for Example #1. Example #1 pastes the final data into cells F8:I22.

I would like example #2 to paste the final data into cell K8:N22.
I would like example #3 to paste the final data into cell P8:S22
I would like example #4 to paste the final data into cell U8:X22
I would like example #5 to paste the final data into cell Z8:AC22

Here is my macro. The macro is also in the attached spreadsheet.

Please Login or Register  to view this content.

[JBeaucaire]

This should take care of it, replace the code in Module21 with this:

Please Login or Register  to view this content.

I removed all the unnecessary selecting, as well.

You shouldn't have 20 empty modules, that's just confusing isn't it?

[rhudgins]

Thanks so much this is perfect! I will delete the empty modules.