Hi guys. I have a range of cells (A1:E) with data referenced from another worksheet (sheet1). With if statement, this range remains empty until sheet1 is updated.
I want to insert a dynamic chart which updates when this range becomes non-empty. I have tried the offset function but it seems not to recognise cells containing formulas as empty even when they are virtually empty.
Bookmarks