Hello Everyone!
This is the first time for me to ask for assistance regarding excel! and so I don't know which forum is the most helpful- I have tried one forum yesterday but no one gave me not even a hint- so I hope I get the required assistance here.
I have an excel sheet with relatively large data set. I have a formula with locked and unlocked reference cells: I want to be able to copy the formula down - so that the unlocked references change; Now the problem is that I want to copy the exact formula to the right of the second cell from top, then change the locked reference cells to the next one below. For example: If the formula in C1 is $A$5+B1, then I copy it down so I have in C2 $A$5+B2, C3: $A$5+B3.... now I want to copy the exact formula in C2 to D2 but changing the locked reference to the one below so I have in D2: $A$6+B2; afterwards I copy the formula in the second populated cell in D coloumn to E so I have in E3:$A$7+B3 and so on. Below is a table for illustration:
<tbody>
</tbody>
Any help is highly appreciated.
Thanks and all best//
This is the first time for me to ask for assistance regarding excel! and so I don't know which forum is the most helpful- I have tried one forum yesterday but no one gave me not even a hint- so I hope I get the required assistance here.
I have an excel sheet with relatively large data set. I have a formula with locked and unlocked reference cells: I want to be able to copy the formula down - so that the unlocked references change; Now the problem is that I want to copy the exact formula to the right of the second cell from top, then change the locked reference cells to the next one below. For example: If the formula in C1 is $A$5+B1, then I copy it down so I have in C2 $A$5+B2, C3: $A$5+B3.... now I want to copy the exact formula in C2 to D2 but changing the locked reference to the one below so I have in D2: $A$6+B2; afterwards I copy the formula in the second populated cell in D coloumn to E so I have in E3:$A$7+B3 and so on. Below is a table for illustration:
A | B | C | D | E | F | |
1 | $A$5+B1 | |||||
2 | $A$5+B2 | $A$6+B2 | ||||
3 | $A$5+B3 | $A$6+B3 | $A$7+B3 | |||
4 | $A$5+B4 | $A$6+B4 | $A$7+B4 | $A$8+B4 |
<tbody>
</tbody>
Any help is highly appreciated.
Thanks and all best//