srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,860
- Office Version
- 365
- Platform
- Windows
Cell A1 has a drop-down list of sheets name,
Cell B1 has,
=MATCH(9.99E+307,INDIRECT(A1&"!A:A"))
From Cell A3 down and across,
=IF(ROW(A3)>$B$1,"",INDIRECT($A$1&"!"&ADDRESS(ROW(A3),COLUMN(A3))))
The problem is that there are some blank cells or rows that gives 0 zeros, How can I update the formula so that if there are blank cells or rows, it leaves it blank.
Thanks,
Cell B1 has,
=MATCH(9.99E+307,INDIRECT(A1&"!A:A"))
From Cell A3 down and across,
=IF(ROW(A3)>$B$1,"",INDIRECT($A$1&"!"&ADDRESS(ROW(A3),COLUMN(A3))))
The problem is that there are some blank cells or rows that gives 0 zeros, How can I update the formula so that if there are blank cells or rows, it leaves it blank.
Thanks,