MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Eliminating Columns with no data


Posted by ddewey on October 10, 2001 6:06 AM

I receive a report that list our product lines across the top of the spreadsheet (columns D:T) with corresponding dollar vaules below. I would a formula or VB code that allows me eliminate or hide the columns where the dollar value is $0.00. I would appreciate any suggestions.


Posted by IML on October 10, 2001 6:30 AM

Probably not the best way, but you could throw totals at the bottom, highlight your list and goto data sort. Hit options, select left to right and sort based on your total row. You can then hide or delete them. Not very flashy, but should work.