Macro to extract information

[serlarra]

I’m constantly receiving list of materials in Excel for different products from which I must separate in other format the information, this separation is made by groups of material (there is a column that specifies this).

What I want to do is a macro that can automatically separate in different worksheets this information and I wanted to know if there is a way to use AutoFilter or another way to identify all different values in the column, from here I think I can make the rest. Or, is there a way to retrieve all different criteria that the AutoFilter shows?

 

[serlarra]

I found a solution for my problem by using AdvancedFilter to copy only unique values. With this I can filter the information from the Macros without having to check the materials used.