SOLVED

linking range of cells in one workbook to range of cells in another workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2188988%22%20slang%3D%22en-US%22%3Elinking%20range%20of%20cells%20in%20one%20workbook%20to%20range%20of%20cells%20in%20another%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2188988%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20link%20a%20range%20of%20cells%20in%20one%20Excel%20workbook%20with%20a%20range%20of%20cells%20in%20another%20workbook%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOver%203000%20cells%20in%20the%20range%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2188988%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2188999%22%20slang%3D%22de-DE%22%3ESubject%3A%20linking%20range%20of%20cells%20in%20one%20workbook%20to%20range%20of%20cells%20in%20another%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2188999%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F988640%22%20target%3D%22_blank%22%3E%40datagirl68%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-an-external-reference-link-to-a-cell-range-in-another-workbook-c98d1803-dd75-4668-ac6a-d7cca2a9b95f%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ECreate%20an%20external%20reference%20(link)%20to%20a%20cell%20range%20in%20another%20workbook%3C%2FA%3E%3C%2FP%3E%3CP%3E(Click%20on%20header%20fo%20rmore%20infos)%3C%2FP%3E%3CP%3EYou%20can%20refer%20to%20the%20contents%20of%20cells%20in%20another%20workbook%20by%20creating%20an%20external%20reference%20formula.%20An%20external%20reference%20(also%20called%20a%20link)%20is%20a%20reference%20to%20a%20cell%20or%20range%20on%20a%20worksheet%20in%20another%20Excel%20workbook%2C%20or%20a%20reference%20to%20a%20defined%20name%20in%20another%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20information%20helped%20you%2C%20please%20mark%20this%20post%20as%20%22Correct%20answer%22%20and%20on%20like%20(hand%20with%20thumbs%20up)%2C%20so%20that%20other%20members%20can%20benefit%20from%20this%20information%20later.%3C%2FP%3E%3CP%3EIf%20the%20information%20did%20not%20help%20you%2C%20please%20ignore%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2189071%22%20slang%3D%22en-US%22%3EBetreff%3A%20linking%20range%20of%20cells%20in%20one%20workbook%20to%20range%20of%20cells%20in%20another%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2189071%22%20slang%3D%22en-US%22%3EWhat%20is%20wrong%20with%20this%20reference%20(see%20below)%3F%20I%20see%20%23VALUE!%20In%20the%20cell.%20For%20some%20reason%20the%20reference%20is%20not%20in%20a%20range%20of%20cells%20bit%20just%20one%20cell.%3CBR%20%2F%3E%3CBR%20%2F%3E%3D'%5BRecruitment%20and%20enrollment%20database%202021_03_05.xls.xlsx%5DData'!%24A%244%3A%24A%243403%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20help%20that%20you%20can%20provide%20would%20be%20much%20appreciated%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

How do I link a range of cells in one Excel workbook with a range of cells in another workbook?

 

Over 3000 cells in the range

 

Thank you!

8 Replies
best response confirmed by datagirl68 (New Contributor)
Solution

@datagirl68 

 

Create an external reference (link) to a cell range in another workbook

(Click on header fo rmore infos)

You can refer to the contents of cells in another workbook by creating an external reference formula. An external reference (also called a link) is a reference to a cell or range on a worksheet in another Excel workbook, or a reference to a defined name in another workbook.

 

If this information helped you, please mark this post as "Correct answer" and on like (hand with thumbs up), so that other members can benefit from this information later.

If the information did not help you, please ignore it.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

What is wrong with this reference (see below)? I see #VALUE! In the cell. For some reason the reference is not in a range of cells bit just one cell.

='[Recruitment and enrollment database 2021_03_05.xls.xlsx]Data'!$A$4:$A$3403

Any help that you can provide would be much appreciated
I was happy to be able to help. You are welcome
When I try to link to another workbook, the destination workbook shows the formula only, and not the data itself. I am unable to edit the link and I am a little confused. Can you help?

@Joolhunt 

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. You could get a precise solution much faster with a file (w/out sensitive data). This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

*Knowing the Excel version and operating system would also be an advantage.

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

 

It is Office 365 Excel 5 and below is a screen shot of the link.
Activity Title 6. Activity Date 7. City
='[2021 CME Check List - 9-1-21 - 12-31-21.xlsx]2021'!$A$2 1/19/2021 Virtual
I hope that helps.
JulieH