Need help stepping down a list based on 3 criteria
 

Currently I have a form and two modules. The form is called frmV2. The first
module is modV2 and second one is Calcs. The way my macro works is you go to
the form and select the database file, then you change 3 criteria. The
commcode, statefip and practice code. Basically once you have put in your 3
criteria you hit run macro. modV2 runs. What it does is search for these 3
criteria in several databases and then return it in a specific form in excel
across multiple worksheets. The Calcs module then runs all of my
calculations. What I have done is to get a listing of all possible
commcode/statefip/practicecode combinations and put them in another
worksheet. What I would like to do is reprogram the macro to go through the
list and retrieve the data and then save the file as what ever combination it
is currently looking for and then run the loop until there are no more
combinations. Is this possible? Any help would be greatly appreciated. Thanks

Need help stepping down a list based on 3 criteria
 

Let me clarify. While going through the list I want it to run the two modules
and then save the file as whatever combination I have in the list. Sorry for
any confusion. Thanks

"Need Help Fast!" wrote:

Currently I have a form and two modules. The form is called frmV2. The first
module is modV2 and second one is Calcs. The way my macro works is you go to
the form and select the database file, then you change 3 criteria. The
commcode, statefip and practice code. Basically once you have put in your 3
criteria you hit run macro. modV2 runs. What it does is search for these 3
criteria in several databases and then return it in a specific form in excel
across multiple worksheets. The Calcs module then runs all of my
calculations. What I have done is to get a listing of all possible
commcode/statefip/practicecode combinations and put them in another
worksheet. What I would like to do is reprogram the macro to go through the
list and retrieve the data and then save the file as what ever combination it
is currently looking for and then run the loop until there are no more
combinations. Is this possible? Any help would be greatly appreciated. Thanks