Can't be done (without a lot of programming). This is not how Excel is
designed. Spreadsheets have lots of columns. Simply put the result of the
multiplication in column C.

Regards,
Fred.

"wineforyou" wrote in message
...
if I have two columns A and B. A is filled with numbers that I want to
multiply by the same number and have that total fill B. But I want also to
be
able to change the number and have all the totals update....how?