Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering Values in a Single Cell to Update Next Empty Cell in a Ra
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering Values and Updating Next Empty Cell in a Range | Excel Worksheet Functions | |||
Entering a Value & Updating the Next Empty Cell in a Range | Excel Worksheet Functions | |||
Entering value into cell via VB code if cell is empty | Excel Programming | |||
Formula is entering a default time when it comes across an empty cell.. | Excel Worksheet Functions | |||
Entering array in single cell | Excel Discussion (Misc queries) |