Do you mean you want to perform some math operation on all the cells when you
input a number into one specific cell?

Assume number is entered in A1.

Assume range is B1:B100

In C1 enter =B1*$A$1 which will multiply by the number in A1

Double-click on fill handle of C1 to copy down.

Another method is to enter a number in an unused cell.

Copy that cell.

Select the range to change and Paste SpecialMultiplyOKEsc

Change the number and do it again.


Gord Dibben MS Excel MVP

On Wed, 19 Mar 2008 05:44:00 -0700, Duma wrote:

I would like to update a range of cells with any number that is input into a
specific cell