How do you want it updated? If the last used cell is C100, and you enter
$1000 into C3, what do you want in C101?

Regardless, I would recommend a more traditional setup. Enter each
transaction as a separate row. Keep a running balance in the last column.
You have an automatic audit trail, the current balance is always the last
row, and you have a history of your balance at every transaction.

Regards,
Fred

"Stilltrader47" wrote in message
...
I am trending a bank account balance. Every time I enter the current value
in cell c3, I would like it to update the value in the next empty cell in
range c5:c200. Thanks

Sony