Is there a way to copy a formula that is on Sheet2 that pulls from Sheet1 and when you paste it to Sheet3 its sheet reference changes to Sheet2 automatically?
For example:
The formula on sheet 2 is =Sheet1!B2
When you copy it over to sheet 3 the result is =Sheet1!B2.
I want the result to be =Sheet2!B2
For example:
The formula on sheet 2 is =Sheet1!B2
When you copy it over to sheet 3 the result is =Sheet1!B2.
I want the result to be =Sheet2!B2