Sep 29 2021 01:21 AM
HI there
I have two separate excel files that I want to link to a third (two separate budget files for different staff that I want to connect to a third master file). I know how to link an individual cell to another excel file but is there a way of linking a large group of cells to another excel file. My knowledge limits me to having to do it cell by cell at the moment.
Thanks
Sep 29 2021 01:32 AM
SolutionSelect the source range.
Copy it (Ctrl+C)
Switch to the destination workbook.
Select the top left cell of where you want the links.
Click the lower half of the Paste button on the Home tab of the ribbon, and select Link.
Sep 29 2021 01:32 AM
SolutionSelect the source range.
Copy it (Ctrl+C)
Switch to the destination workbook.
Select the top left cell of where you want the links.
Click the lower half of the Paste button on the Home tab of the ribbon, and select Link.