Jun 08 2022 09:47 PM
Hi,
I'm trying to make a cell in sheet A of workbook 1 display the cell from sheet X in workbook 2.
Both workbooks are in the same parent folder with different sub folders.
I want all this to be done with OneDrive apps, not desktop app. Any help would be greatly appreciated!
Thanks
Jun 08 2022 11:54 PM
Create an external reference between cells in different workbooks
Open the workbook that will contain the external reference (the destination workbook, also called the formula workbook) and the workbook that contains the data that you want to link to (the source workbook, also called the data workbook).
In the source workbook, select the cell or cells you want to link.
Press Ctrl+C or go to Home > Clipboard > Copy.
Switch to the destination workbook, and then click the worksheet where you want the linked data to be placed.
Select the cell where you want to place the linked data, then go to Home > Clipboard > Paste > Paste Link.
Excel will return the data you copied from the source workbook. If you change it, it will automatically change in the destination workbook when you refresh your browser window.
To use the link in a formula, type = in front of the link, choose a function, type (, and then type ) after the link.
Hope I could help you with these information / links.
I know I don't know anything (Socrates)