There is a macro function by running which sorting appears on cell C2. I didn’t find it in nete, but I didn’t find the type I clicked on the triangle and choose a group from the list, after I chose Excel it shows everyone who is in this group, all the others are erased .... I don’t understand how to do it

  • Gave the answer to installing the filter with conventional tools, as the question of the macro function is not clear. Is it exactly and the filter is installed with its application? It is necessary to show the function code. ____ Group selection - the rest are erased ... And if you need to choose another - there is no data anymore? Describe the task more precisely - vikttur

1 answer 1

Installing a filter without using VBA.

Select data, set filter :

The Data-Filter tab

You can select only the "table header", but if there are blocks in the data, separated by empty lines, the lines below the first empty filter will not fall.

Filter Option - Smart Table :

select data tab Insert-Table . The data range will turn into a formatted filter table.

If the filter needs to be set with a macro , you can write the actions described above with the macrorecoder:

Developer-Record_Macro tab or

View-Macros-Macro Record tab

It should be something like this:

Sub Макрос1() Range("A1:C10").Select Selection.AutoFilter End Sub

Macro-coder writes too much, it is not necessary to select a range to set the filter:

 Range("A1:C10").AutoFilter

Enter VBA editor:

press Alt + F8-Login or Alt + F11

  • Well, as I explain in more detail, I chose a group from the list in the filter (in the group column in the mix), the macro removed all unnecessary, leaving only the group that I chose, if I chose another group again, then all the other groups that do not match, they disappear and only the group in the column that I have chosen remains, so it will be clearer - komra23
  • Why do you think you need a macro? This can be done with a regular filter. Group name where is it? - vikttur
  • macro, because I wrote this task, but I don’t know how to do this filter, I can say that I have everything else, the names of the groups are in column C - komra23
  • Added in reply ... - vikttur
  • You do not know by chance how you can do "offer to save the data sheet" in txt doc. what thread (puolny way to tht .... - komra23