Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-17-2020, 12:10 AM
Marcia's Avatar
Marcia Marcia is offline Hide Row With Zero Values Windows 7 32bit Hide Row With Zero Values Office 2013
Expert
Hide Row With Zero Values
 
Join Date: May 2018
Location: Philippines
Posts: 553
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, 17 views)

Last edited by Marcia; 03-17-2020 at 02:24 PM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Table with values from several locations and years - need to find comp values Ricardo Sousa Excel 9 07-27-2018 02:06 AM
Hide Row With Zero Values Table with values from several locations and years - need to find comp values Ricardo Sousa Excel 6 06-09-2018 10:51 PM
Display multiple values as new values based on selection from template. MvdB Excel 2 09-29-2015 08:51 PM
Hide rows in multiple columns based on zero values Deane Excel Programming 19 06-23-2015 11:24 PM
How to Hide/Un-hide a worksheet based on cell on another sheet. easton11 Excel Programming 1 06-02-2015 12:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft