Excel rows hidden when it is empty

allex011 · #1 03-13-2020, 11:16 PM

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

NoSparks · #2 03-14-2020, 06:07 AM

Perhaps like this

allex011 · #3 03-14-2020, 08:31 AM

Thank you, very much

Marcia · #4 03-16-2020, 06:54 PM

Quote:

Originally Posted by NoSparks

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.

NoSparks · #5 03-16-2020, 09:33 PM

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.

Marcia · #6 03-16-2020, 09:55 PM

Thank you, I will start a new thread then.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 vba to check to check if two columns are empty	subspace3	Excel Programming	5	07-09-2015 04:45 PM
Create a New Sheet from Existing Sheet with Specific Columns	malam	Excel Programming	1	10-17-2014 10:01 PM
Compare data in different columns in an Excel sheet	kgfendi	Excel	5	05-16-2009 05:42 PM