Support Board
Date/Time: Sun, 24 Nov 2024 14:24:47 +0000
Post From: Excel cross spreadsheet referencing
| [2013-10-29 00:33:24] |
| 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.
|