Filter data using keys in dictionary

Hello,

I am working on the last step in a very long project and cannot figure out how to filter my data based on keys in a dictionary.

The data I am working with (in the ActiveSheet) has a list of names (in column 6). I want to add these names as keys in the dictionary and the corresponding location (in column 7) as the items. Then, I want to filter the data by each key in the dictionary, copy the filtered data, and paste it into another workbook. I have included the code I have so far. It seems to work exactly how I want as long as I'm not using the dictionary. What am I missing?

Thanks!!

Please Login or Register  to view this content.

Hi..

First... Check out snb's site.. he has a great amount of info on the Scripting Dictionary..

http://www.snb-vba.eu/VBA_Dictionary_en.html

Thanks apo - I actually found this site, but it seems I didn't look carefully enough.

In case anyone stumbles onto this thread looking for answers, I used the Excel Index function to query the dictionary:

Please Login or Register  to view this content.

and found this answer in section 14.3 of the site that apo referenced above.