Hi Dears;
On my table; my activities information coming from formula based on criteria; regarding that not all of them has quantity (Some of them empty but it is changing by criteria). For example when you use one criteria row-1,3,5,7 is empty (On the same column) and for other criteria row-2,4,6,8 is empty. I want to use a filter without macro when criteria is changing I want to see always not empty cells. Is it possible?
Many thanks...
Hi Gokhan,
You haven't attached a workbook I don't know if you have your data in an Excel Table or not. But if you do then you could just use the table filters.
If you haven't got your data in a table, select the data, then CTRL+T to create a table.
Failing those options, select the data you want to filter and then from the Ribbon -> Data -> Filter.
If you need more help please attach your workbook.
Regards
Phil
Hello Phil;
I added the file. I want to filter (hide blanks) on column B and when I change the criteria which is highlighted by yellow on the same sheet; I don't want to see any blank cell. Is it possible without macro?
Thanks...
Hi Gokhan,
You will either have to use VBA for this, or do it manually by going to the Ribbon -> Data -> Sort & Filter -> Reapply.
Attached is VBA to do the job.
Private Sub Worksheet_Change(ByVal Target As Range)
AutoFilter.ApplyFilter
End Sub
Regards
Phil
