SOLVED

Linking different excel files

Copper Contributor

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

2 Replies
best response confirmed by tour_contact (Copper Contributor)
Solution

@tour_contact 

Select 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.

Thanks. Very helpful
1 best response

Accepted Solutions
best response confirmed by tour_contact (Copper Contributor)
Solution

@tour_contact 

Select 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.

View solution in original post