Entering a Value & Updating the Next Empty Cell in a Range
I would like to enter values in a single cell and have it update each time
the next consecutive empty cell in a cell range. For example, cell c5 is the
data entry cell:
Each time I enter a value the next empty cell in range a10 through a20 is
updated. And the previous entered is frozen to values. I am thinking I have
to include a "edit-copy-edit-paste special- values" macro to freeze every
entry after it places.
Every time I enter a value in c5, the below range update. Your input on how
to do this will be appreciated.
A
10 55
11 84
12 73
13 12
14 22
15
16
17
18
19
20
|