Reply to thread

Message: [QUOTE="Stilltrader47, post: 6438690"] 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 [/QUOTE]