group filtering

[kijijijt]

I would like to filter out blanks in column K in all sheets within a workbook. For some reason when the sheets are grouped the filter option is not available. I appreciate any help. thanks.

 

[Ben McClave]

Assuming you have data in columns A:J, this should work:

Sub FilterAll()
Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
WS.Cells.AutoFilter 11, "<>"
Next
End Sub

-Ben

 

[kijijijt]

I would like to filter out blanks in column K in all sheets within a workbook. For some reason when the sheets are grouped the filter option is not available. I appreciate any help. thanks.

works, thanks.