May 25 2022 05:32 PM
Good morning,
Can you please help with this issue?
I need to copy formulas placed in column B and C to the right. Both formulas are linked to another works-sheet. When I select both formulas and drag it to the right it updated the cell reference incorrectly ( it jumps from K39 to M 39 and from C6 to F6 and I want it as a example below (from K39 to K39 and c 6 to E6 and ( in alphabetical order /+1 increment)
Is there a shortcut do it or a formula?
I have also tried to select the cells individually with a "Command"button ( I am using iMac) and drag it but it does not work either
You help would be much appreciated it!
Thank you
| |||||
Name | Days | Value $ | Days | Value $ | |
John Smith | Plan!K39*Plan!$K$22 | $C$6*D6 | Plan!L39*Plan!$L$22 | $C$6*E6 | |
Mark Green | Plan!K40*Plan!$K$22 | $C$7*D7 | Plan!L40*Plan!$L$22 | $C$7*E7 | |
May 25 2022 05:56 PM
May 25 2022 07:23 PM
May 25 2022 08:59 PM
@KamilaG You could also replace the cell reference with an INDEX in the formula something like:
=$C$6*INDEX(6:6,1, COLUMN()/2-1)
COLUMN() will return the column # of the cell it is in so /2 increments by 1 so you just need the correct offset.