Filtering data using a dictionary

[Demirion]

Hi, I would like to create a macro that will filter the data, but the problem is, I don't know exactly what the data will be in the file. For this purpose, I used a dictionary that goes through a given column and saves the keys that I want to filter later. Unfortunately, I don't know how to get data from this dictionary. Below, the loop that goes through the given column. I added Debug.Print to check if the dictionary is working properly.

For Each key In dictCity.Keys
Set oCity = dictCity(key)
With oCity
Debug.Print key
ws1.Range("A1").Autofilter Field:=1, Criteria1:=key, Operator:=xlFilterValues
End With
Next key

 

[Demirion]

Thanks for the help. Everything works rigidly. Now I go back to the dictionaries. Earlier, I only mentioned one dictionary because I didn't want to complicate the macro. There must be three dictionaries. One is for cities (column A), the other is for users (column B), and the third is for errors (column C). After creating a dictionary with cities, I filter by items from the dictionary. After filtering, I create a dictionary with users who are in a given city and also using items from the dictionary filters data in the table with users. Finally, from what is left, I create a third dictionary with errors which I use to filter the data on the sheet with errors. And this is how I would like to generate an email for users. As I mentioned rigidly, I managed to do it for a single city and user. If I had to do it rigidly for everything, it would take a long time because there are several thousand items. In addition, I do not know what exactly will be in the file, so it would work hard only for a specific file. I know this is a long and complicated macro but maybe you used to do a similar one and could you guide me on how to do it?