Prev: Drag Mouse and Add-up
Next: Round
From: Stilltrader47 on 26 Mar 2010 00:18
How can I update the next consecutive empty cell in a range each time a value
is entered in the same cell?

For eample, I enter bank account balances in cell c4. Each time the next
consecutive empty cell in range c6:c20 updates with the value entered.

Thanks for your help.
From: ozgrid.com on 26 Mar 2010 02:38
Do you mean

=$C$4 in the Range C6:C20?



--
Regards
Dave Hawley
www.ozgrid.com
"Stilltrader47" <Stilltrader47(a)discussions.microsoft.com> wrote in message
news:7E0FFB22-F089-47AF-B64B-87DA60B19C7D(a)microsoft.com...
> How can I update the next consecutive empty cell in a range each time a
> value
> is entered in the same cell?
>
> For eample, I enter bank account balances in cell c4. Each time the next
> consecutive empty cell in range c6:c20 updates with the value entered.
>
> Thanks for your help.

 | 
Pages: 1
Prev: Drag Mouse and Add-up
Next: Round