Hi,
So i've been to trying figure out a formula or most likely a Macro that would solve my issue here.
I have a column that has formulas in every cells (say D2:D30) and depending on the choices you make on that sheet, this column will display the information.
It works great but I would LOVE to know if there's actually a way to hide the cells that return nothing, so that it would be aesthetically more pleasing.
To be clear, right now the end result looks a bit like this:
result1
result2
result3
result4
result5
result6
result7
...
.. and of course I want it to look like this:
result1
result2
result3
result4
result5
result6
result7
...
even though, between "result1" and "result2" there is a cell with a formula. Sorta like a hide cell if empty macro (or if cell="").... i don't know.
I'm at a loss here, any help would be REALLY appreciated.
Thanks a million
Bookmarks