Forum Discussion
sophiejlear
Sep 09, 2021Copper Contributor
Cross referencing
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
Sort By
- Riny_van_EekelenPlatinum Contributor
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/