Hi all,
I have set up a table with formulas and produced extra line needing people to complete less information each time. I have also set up a number of charts which I'd like to set up initially so they are completed with further information as and when it is added. However I would like these non completed lines ommitted until they are completed.
Is there any way though that you can easily hide all information that hasn't been added, so i.e.
EACU April 9'18 - April 15'18
EACU April 16'18 - April 22'18
EACU April 23'18 - April 29'18........ etc.
Otherwise the chart looks as though the value was 0 for these new months.
I have tried using hide, but it only allows you to hide blank cells and this doesn't work as there is something within column (A) and J has #DIV/0.
Any help/advice would be greatly appreciated.
Many thanks
Bookmarks