| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste changing cell contents to consecutive cells in a column
I would like for the contents of a cell (ie: A21) to post to a cell in
another column (ie: D1). However, when the contents of A21 change I would like for the new figure to post to the next available cell in column D (D2). I want that process to continue in consecutive cells as the value of A21 continually changes. Column A is a column in which I am adding figures. A21 is the sum. D would be a record of all of those sums. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy the contents of a range of text cells and paste into one cell? | Excel Discussion (Misc queries) | |||
| paste formula to each cell in a column without changing values | Excel Worksheet Functions | |||
| Insert contents of various cells in a column into one cell? | Excel Discussion (Misc queries) | |||
| How do I paste into 'consecutive' cells? | Excel Discussion (Misc queries) | |||
| copy every 30th cell in the column into consecutive cells in anoth | Excel Worksheet Functions | |||
Threaded Mode
