Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting a cell for fill-in by previous cells
I have values entered into a column. In the next columns over I'd like to be
able to simply enter X or another marking value so that the numbers from that row carry over without me having to enter in the number every time I want to use it. Example: A B C D 1 X X 2 X X 3 X X X 4 X So that either the X's turn into the numbers from column A or when I sum the values at the bottom of columns B, C, and D they add up to 6, 5, and 8 respectively. Any help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Request: Fill in empty cells with previous Filled cell in column | Excel Worksheet Functions | |||
set up a formula to automatically fill down from previous cell | New Users to Excel | |||
Help! I want to fill cells as a result of selecting a value from a list in another cell. | Excel Worksheet Functions | |||
fill cells with a value from two previous cells | Excel Discussion (Misc queries) | |||
How would I fill blank cells with the data from a previous cell? | Excel Discussion (Misc queries) |