Dale Fye
asked on
Identify whether worksheet contains rows that meet more than one criteria
Sheet #1 contains about 500 rows with column C defined as Group (numeric) and column D defined as Sub-Group (numeric), There are only about 75 unique combinations of Group/Sub-Group.
As part of a much larger process, the first step is to identify which combinations of Group/Sub-Group exist in Sheet #1 which don't exist in Sheet #2, which also contains Group (column A) and sub-group (Column B).
My intent is to loop through the rows of Sheet #1 and confirm whether there is a matching Group/Sub-group in Sheet #2. If not, I'll add that Group/sub combination to a message and after checking all of the rows, present a message box for my user.
The looping works just fine, I just have not been able to figure out how to determine whether a row matches more than one criteria. I know I could loop through each row of Sheet #2 and test both cells agains the cells from Sheet #1, but I'm looking for a more elegant method.
As part of a much larger process, the first step is to identify which combinations of Group/Sub-Group exist in Sheet #1 which don't exist in Sheet #2, which also contains Group (column A) and sub-group (Column B).
My intent is to loop through the rows of Sheet #1 and confirm whether there is a matching Group/Sub-group in Sheet #2. If not, I'll add that Group/sub combination to a message and after checking all of the rows, present a message box for my user.
The looping works just fine, I just have not been able to figure out how to determine whether a row matches more than one criteria. I know I could loop through each row of Sheet #2 and test both cells agains the cells from Sheet #1, but I'm looking for a more elegant method.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Patrick,
Great article, but what I didn't see mentioned is anything about the dictionary order. If I load a dictionary in a particular order and then use:
For each x in MyDictionary
debug.print MyDictionary.item(x)
next
Will the items be printed out in the order they were loaded?
Great article, but what I didn't see mentioned is anything about the dictionary order. If I load a dictionary in a particular order and then use:
For each x in MyDictionary
debug.print MyDictionary.item(x)
next
Will the items be printed out in the order they were loaded?
ASKER
AgeOfEmpires,
Will give this a shot and see how I like it.
Will give this a shot and see how I like it.
>>Will the items be printed out in the order they were loaded?
Good question! Never tested it :)
Good question! Never tested it :)
ASKER
Thanks,
https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/A_3391-Using-the-Dictionary-Class-in-VBA.html