What are you wanting to put in range B139:B150? Are you wanting to put the
value you entered in J29 in the next availabe cell in B139:B150? If so, what
happens when B139:B150 gets full?

--
Cheers,
Ryan


"Stilltrader47" wrote:

I would appreciate help with a macro or function to accomplish the following:

I would like to enter values in a single "data entry" cell and have it
update
the next consecutive empty cell in a cell range. For example, cell j29 is the
data entry cell:

Each time I enter a value in j29, the next empty cell in range b139 through
b150 will update. And each value that populates in b139:b150 should be
frozen to a "value". 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 j29 the below range should update. Your input
on how
to do this will be appreciated.

B
139 55
140 84
141 73
142 12
143 22
144
145
146
147
148
149
150