I want to insert a value from a cell (say A1) into another cell. This 'other cell' is to be the first non-zero cell working downwards in a column of cells (all of which are numbers), most (but not all) of which will contain zero. The values in the column are all derived from formulae. I want the value in cell A1 to be inserted into that first non-zero cell in the column, replacing the zero with the value in cell A1, without affecting anything else above or below it in the column. Can this be done without using VBA? If it has to be VBA, then how?