Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-14-2018, 11:53 PM
LearnerExcel LearnerExcel is offline How to Hide/Unhide empty rows with formula based on criteria in G3? Windows 7 32bit How to Hide/Unhide empty rows with formula based on criteria in G3? Office 2013
Advanced Beginner
How to Hide/Unhide empty rows with formula based on criteria in G3?
 
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default How to Hide/Unhide empty rows with formula based on criteria in G3?


How to Hide/Unhide empty rows (with formula inside the Cells) based on criteria in G3?

Please find attached the Excel files for reference.

Note: This is required for one of my friends who doesn't know much about MS Office.
Attached Files
File Type: xlsm AutoFill.xlsm (57.9 KB, 10 views)
File Type: xls TempData.xls (57.5 KB, 10 views)
Reply With Quote
  #2  
Old 02-15-2018, 07:17 AM
NoSparks NoSparks is offline How to Hide/Unhide empty rows with formula based on criteria in G3? Windows 7 64bit How to Hide/Unhide empty rows with formula based on criteria in G3? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Have a look at the video here for an understanding of how advanced filter works.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA - Deleting Rows (criteria based) BobbyG Project 1 07-31-2017 08:55 AM
Hide Rows that are empty inserted by Quick parts. Anto_bt Word 6 12-15-2015 05:15 PM
How to Hide/Unhide empty rows with formula based on criteria in G3? Hide / unhide Rows NullVBA Excel Programming 4 12-09-2015 05:10 AM
Hide/Unhide Text Based on Drop Down Selection gw1500se Word 3 02-19-2015 12:17 PM
How to Hide/Unhide empty rows with formula based on criteria in G3? Hide/Unhide a Block of Text Based on Choice Selection inquirer Word VBA 7 09-22-2014 04:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:06 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