![]() |
#1
|
|||
|
|||
![]()
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 | |
|
![]() |
||||
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 |
![]() |
subspace3 | Excel Programming | 5 | 07-09-2015 04:45 PM |
![]() |
malam | Excel Programming | 1 | 10-17-2014 10:01 PM |
![]() |
kgfendi | Excel | 5 | 05-16-2009 05:42 PM |