Kindly assist me do this simple formula.
I wish to drag down a formula while incrementing the column reference as in below example
Formula in cell A2 is =E2-'Project Dispatch'!G4
A3 is =E3-'Project Dispatch'!H4
A4 is =E4-'Project Dispatch'!I4
Hi, that could be
in A2 to drag it down
@Sergei Baklan solution works fine. Thanks!!!
@NickNgolo , you are welcome