Cross referencing

%3CLINGO-SUB%20id%3D%22lingo-sub-2736922%22%20slang%3D%22en-US%22%3ECross%20referencing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2736922%22%20slang%3D%22en-US%22%3E%3CP%3Ehow%20all%2C%20new%20to%20excel%2C%20can%20someone%20tell%20me%20if%20cross%20referencing%20can%20be%20done%20from%20one%20spreadsheet%20to%20another%2C%26nbsp%3B%3C%2FP%3E%3CP%3Etried%20looking%20on%20google%20and%20it%20looks%20like%20this%20can%20only%20been%20done%20from%20one%20work%20sheet%20to%20another.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eim%20basically%20trying%20to%20copy%20and%20paste%20a%20load%20of%20data%20-%20anyone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2736922%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2736949%22%20slang%3D%22en-US%22%3ERe%3A%20Cross%20referencing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2736949%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1151250%22%20target%3D%22_blank%22%3E%40sophiejlear%3C%2FA%3E%26nbsp%3BJust%20Googled%20and%20this%20is%20the%20first%20that%20came%20up.%20It%20deals%20with%20both%20referencing%20between%20sheet%20in%20a%20workbook%20and%20between%20workbooks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.howtogeek.com%2F426633%2Fhow-to-cross-reference-cells-between-microsoft-excel-spreadsheets%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.howtogeek.com%2F426633%2Fhow-to-cross-reference-cells-between-microsoft-excel-spreadsheets%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

how all, new to excel, can someone tell me if cross referencing can be done from one spreadsheet to another, 

tried looking on google and it looks like this can only been done from one work sheet to another.

 

im basically trying to copy and paste a load of data - anyone help?

1 Reply

@sophiejlear Just Googled and this is the first that came up. It deals with both referencing between sheet in a workbook and between workbooks.

 

https://www.howtogeek.com/426633/how-to-cross-reference-cells-between-microsoft-excel-spreadsheets/