Duma,

Select the range of cells, type the formula

=$A$1

(but with the cell address of the specific cell) and press Ctrl-Enter.

Or, type = and then select the specific cell and press Ctrl-Enter. This is the better way if the
cell is on another sheet.

HTH,
Bernie
MS Excel MVP


"Duma" wrote in message
...
I would like to update a range of cells with any number that is input into a
specific cell