Thanks Don, I will stay in one group.

Thanks for the macro below I'll try. Let me clarify my objective, to help
you better understand the code I need.

For example, I want to always enter the new value in cell j29. Each entry
will update the value to the next consecutive empty cell in range c49:c60.
Your help is appreciated. Tom


"Don Guillett" wrote:

Please post in ONLY ONE group.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
??
cells(rows.count,"c").end(xlup).row+1,"c").value=c ells(3,"c")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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


.