View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stilltrader47 Stilltrader47 is offline
external usenet poster
 
Posts: 36
Default 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