serlarra
Mechanical
- Jun 2, 2011
- 8
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?
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?
