The excel file exceeds the limit of this forum..

Thats why I havent posted it?

To give you a bit of background on the sheet. The sheet pulls new data every month and certain rows are always blank so in order to only show rows with values and therefore make the sheet more compact I need to hide zeros. The word doc does show zeros as '-'. No the budget sheet total is not the sum of the previous columns.

But I see what you mean.. maybe if I make a column that sums all of the columns I can just use the code on that column only? could you provide a code for this? say in column T.

Really appreciate the help thus far.