#1
|
|||
|
|||
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 Last edited by allex011; 03-14-2020 at 03:06 AM. |
#2
|
|||
|
|||
Perhaps like this
|
#3
|
|||
|
|||
Thank you, very much
|
#4
|
||||
|
||||
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.
|
#5
|
|||
|
|||
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. |
#6
|
||||
|
||||
Thank you, I will start a new thread then.
|
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 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 |