Updating Consecutive Cells in a Range
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. |
Updating Consecutive Cells in a Range
Do you mean
=$C$4 in the Range C6:C20? -- Regards Dave Hawley www.ozgrid.com "Stilltrader47" wrote in message ... 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. |
All times are GMT +1. The time now is 03:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com