Hi All,

Im trying to mirror cells within a spread sheet, and currently have =sheetnumber!cellnumber.

The cell format doesnt copy over and also if the cell is blank it puts a 0 in the copied sheets cell. Is there a better way of doing this please - and if so how?

Thanks