Support Board

Date/Time: Sun, 19 May 2024 21:54:12 +0000

Post From: Excel cross spreadsheet referencing

[2013-10-29 00:33:24] Link To Thread - Link To Post [Go To First Post]
vegasfoster - Posts: 444
Just open both spreadsheets and reference to the second spreadsheet. For example, if the spreadsheets are name Spreadsheet1 and Spreadsheet2, then in Spreadsheet1, sheet1, cell A1, type "=" and then click on Spreadsheet2, sheet1, cell A1 and hit "enter". The syntax will be =[Spreadsheet2.scwbf]Sheet1!$A$1. It is my understanding in the new in-house spreadsheet that you will not be able to reference between files, but you will need to output the data for each chart to a separate sheet in the same file and reference between those sheets. Someone correct me if that is wrong.