I am trying to achieve the following scenario.
- value of G1 has formula set to (=F1)
- When I copy the formula to other cells in column G, I want the formula to saty same (=F1) instead of dynamically getting updated to next cell number in the F column like (=F2) etc.