A macro that could hide rows...?

[joseemorales]

I need to hide rows that show zero (0) in a certain cell for printing purposes. Is this possible with a macro?
All these cells are located in the same column.
Thanks,

JM

 

[yosi]

use custom views to save filter results
1- filter the list to hide all 0 in the column
2- define the printing area
3- save the result in custom view for future

 

[joseemorales]

Hi again,

Can I have multiple filters in the same worksheet? If so, how?

I have three different tables that I want to show and each one has a different criteria for filtering.

Thanks,
JM

 

[yosi]

you may use only one filter in a sheet
the best way of handle tables is to consolidate them to one

add to each table one more column with table name, copy-paste one beneeth the other ( be careful with columns headings ) then you can sort, filter, subtotal or use PivotTable