Just select filter over column and save excel sheet

Help Studio
, ,
21

Hi
VBA code
Sub ApplyFilter( )
Dim header As Range
Set header = [e21:k21]
’ Create filter
header.AutoFilter
’ Apply filter to show top 10 volume days.
header.AutoFilter 6, “10”, XlAutoFilterOperator.xlTop10Items
End Sub

edit for your file

Regards,
LNV

22

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.