Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If cell not empty, then display from range | Excel Discussion (Misc queries) | |||
Referring to a cell by entering an integer; RANGE functions | Excel Worksheet Functions | |||
Preventing user entering duplicate values in a cell range | Excel Worksheet Functions | |||
Formula is entering a default time when it comes across an empty cell.. | Excel Worksheet Functions | |||
Picking up the last non-empty cell in a given range | Excel Discussion (Misc queries) |