I have 2 sheets and I want to copy formula from sheet1’s cell into sheets2’s cell.
sheet1CellFormula = “=A10”;
and If I copy this formula into sheet2 cell, currently sheet2 cell formula is getting copied like this: “=A10” (which is incorrect, this way it is referring to A10 cell of sheet2 not sheet1),
It should refer to A10 cell of Sheet1 i.e. expected formula is =“Sheet1!A10”
Please suggest how to achieve this.