group filtering
 

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.

group filtering
 

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

group filtering
 

On Thursday, September 27, 2012 7:30:07 AM UTC-4, wrote:
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.