Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query criteria based on a changing criteria list | Excel Discussion (Misc queries) | |||
Extract list of units based on error criteria to new list | Excel Worksheet Functions | |||
Extract list of units based on error criteria to new list | Excel Worksheet Functions | |||
Criteria Based List | Excel Discussion (Misc queries) | |||
Stepping through an autofiltered list | Excel Programming |