I inherited an excel template that I want to edit. I have a large table made up of references to various other parts of the sheet, but references are not in a simple enough pattern to use the fill functions.
This table is used as the source data for a different program. I need the table not to display zeros.
So, I need a macro to change each cell such that =A1 to =IF(A1=0,'',A1).
Thanks!
Bookmarks