Hi!

Is there a way to reference an existing chart in a formula on a new spreadsheet?

Another department has provided me with a spreadsheet (created in the same version of Excel) with a ton of data on it. I would like to be able to reference individual pieces of this spreadsheet in the formulas I'm using on the new spreadsheet - is this a possibilty? Or, do I have to go through the tedious task of entering all the existing data on my own spreadsheet before I can reference it?

Thanks!