Thread: [Solved] Hide Row With Zero Values
View Single Post
 
Old 03-17-2020, 12:10 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Hide Row With Zero Values
Hi. I have several sheets in 1 workbook that have Ending balances in columns H and I. I googled first hoping that I would find a solution to my problem but found nothing that met my exact requirements. The samples that I found refer to a single column only, not 2 columns.
Every month after supplying the data for my monthly reports, I filter the rows under Col H and I with zero values.
I would like a code that, when run will hide the rows in col H and I that have zero values.
Thank you. Sample sheet attached.
Attached Files
File Type: xlsx Hide Rows with Zero Values.xlsx (20.5 KB, 15 views)
Last edited by Marcia; 03-17-2020 at 02:24 PM.
Reply With Quote