Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2020, 11:16 PM
allex011 allex011 is offline Excel rows hidden when it is empty Windows 7 32bit Excel rows hidden when it is empty Office 2007
Advanced Beginner
Excel rows hidden when it is empty
 
Join Date: Dec 2017
Posts: 39
allex011 is on a distinguished road
Default Excel rows hidden when it is empty

I need help with one sheet who collect values from different workbooks.Is it possible that in that sheet to have hidden rows until they are filed with values from another workbooks?



Thank in andvanced
Attached Files
File Type: xls Sheet1.xls (28.0 KB, 7 views)

Last edited by allex011; 03-14-2020 at 03:06 AM.
Reply With Quote
  #2  
Old 03-14-2020, 06:07 AM
NoSparks NoSparks is offline Excel rows hidden when it is empty Windows 10 Excel rows hidden when it is empty Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Perhaps like this
Attached Files
File Type: xls Sheet1.xls (33.5 KB, 10 views)
Reply With Quote
  #3  
Old 03-14-2020, 08:31 AM
allex011 allex011 is offline Excel rows hidden when it is empty Windows 7 32bit Excel rows hidden when it is empty Office 2007
Advanced Beginner
Excel rows hidden when it is empty
 
Join Date: Dec 2017
Posts: 39
allex011 is on a distinguished road
Default

Thank you, very much
Reply With Quote
  #4  
Old 03-16-2020, 06:54 PM
Marcia's Avatar
Marcia Marcia is offline Excel rows hidden when it is empty Windows 7 32bit Excel rows hidden when it is empty Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by NoSparks View Post
Perhaps like this
I tried this by pasting formulae in sheet 1 with another workbook as the reference. The macro did not hide the rows containing cells with formulae even if the result is zero.
Reply With Quote
  #5  
Old 03-16-2020, 09:33 PM
NoSparks NoSparks is offline Excel rows hidden when it is empty Windows 10 Excel rows hidden when it is empty Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Cells with formulas are not empty and cells with formulas do not trigger the Worksheet_Change event.


If you're having issues with what you have start a new thread.
Reply With Quote
  #6  
Old 03-16-2020, 09:55 PM
Marcia's Avatar
Marcia Marcia is offline Excel rows hidden when it is empty Windows 7 32bit Excel rows hidden when it is empty Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thank you, I will start a new thread then.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook kiwimtnbkr Excel Programming 4 06-26-2019 11:30 AM
Locate data from 3 columns in all of excel sheet habib90 Excel 3 04-18-2016 08:54 AM
Excel rows hidden when it is empty Excel vba to check to check if two columns are empty subspace3 Excel Programming 5 07-09-2015 04:45 PM
Excel rows hidden when it is empty Create a New Sheet from Existing Sheet with Specific Columns malam Excel Programming 1 10-17-2014 10:01 PM
Excel rows hidden when it is empty Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:48 AM.


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