I need help suppressing zeros on my worksheet. I created a formula
=IF(ISBLANK(B8),"x",IF(OR(D8<>0,E8<>0,F8<>0,G8<>0,H8<>0,I8<>0,J8<>0,K8<>0,L8<>0,M8<>0,N8<>0,O8<>0,P8<>0,Q8<>0),"x",""))
, then a macro that would apply the filter.
Sheets("Forecast Detail").Select...