Hi,
I have a workbook with following formula in cell G3 in Sheet1 which is referencing Sheet2. When I try to copy this formula to cell C3 in Sheet1, the relative cell reference part is the same as source and won’t ajust…...following as the same behavior as Excel. How to achieve this behavior...may not update as they do in Excel. You can use the Copy method...