I've always wondered why it isn't possible to "copy" and "paste" a reference in Excel. Let me explain...
Let's say that I want the cell WorksheetA!A1 to reference cell WorksheetZ!B2, i.e. "=WorksheetZ!B2" would be the formula entered in cell WorksheetA!A1.
Oftentimes, this involves figuring out which cell I want to reference, i.e. WorksheetZ!B2, then navigating back to WorksheetA, then entering "=" in cell WorksheetA!A1, then navigating back to WorksheetZ to select cell WorksheetZ!B2.
It would be much easier to be able to "copy" a reference to cell WorksheetZ!B2 while I'm on WorksheetZ, after which I would navigate to WorksheetA, where I would be able to "paste" this reference in cell WorksheetA!A1, thus automagically creating the formula above. Steps avoided, time saved.
Does what I'm describing make sense? Is there a way to do this that I'm simply not aware of after all these years using Excel?
Let's say that I want the cell WorksheetA!A1 to reference cell WorksheetZ!B2, i.e. "=WorksheetZ!B2" would be the formula entered in cell WorksheetA!A1.
Oftentimes, this involves figuring out which cell I want to reference, i.e. WorksheetZ!B2, then navigating back to WorksheetA, then entering "=" in cell WorksheetA!A1, then navigating back to WorksheetZ to select cell WorksheetZ!B2.
It would be much easier to be able to "copy" a reference to cell WorksheetZ!B2 while I'm on WorksheetZ, after which I would navigate to WorksheetA, where I would be able to "paste" this reference in cell WorksheetA!A1, thus automagically creating the formula above. Steps avoided, time saved.
Does what I'm describing make sense? Is there a way to do this that I'm simply not aware of after all these years using Excel?