We currently export a report from our company file to excel - I would like to have a macro written which will help make the data useful.
First - excel should have the macros enabled always.
Second - once someone hits the appropriate key - all of the zero values in the spread sheet to not display 0 - it should only display a blank field.
and lastly - the macro / VBA should look at the values in a certain row range (this is a constant and unchanging range), if the value of the cell within the range is zero, then that column should be deleted. this would need to be repeated for the entire range on the row. the constant range in the excel spread sheet is $I$12:$FR$12
Can someone help please
Thank you very much for your help