I need a macro to do the following.
Look at Tabs named 2011 and 2012, do the same on each tab
Range from S126 to S561
Replace sum(range) with round(sum(range),0)
For any cell in the range that has the formula, the other cells are blank.
thanks in advance.
Look at Tabs named 2011 and 2012, do the same on each tab
Range from S126 to S561
Replace sum(range) with round(sum(range),0)
For any cell in the range that has the formula, the other cells are blank.
thanks in advance.