Is there a way to pull cells from multiple excel spreadsheets into one summary sheet?

Question

Hi,

Let's say that I have 100 spreadsheets from different organizations detailing the demographics of the people they serve.

Is there any formula that I can type into the summary sheet that will add up all of the cells in A1 (for instance), in my summary page?

Thanks for any input.

Answer 1

I know it can be done because at my last job I made a excel spread sheet that could use the cells from other spread sheets within the same umbrella. However, I am now disabled and I take lots of pain meds that don't allow my memory to function property so I can't tell you how. Hopefully someone will answer with how to do it.

Answer 2

Yep it'd be like this



='[name of the file.xlsx]Sheet1'!$A$1 + '[name of file.xlsx]Sheet1'!$A$1 + etc

Answer 3

seem into Paste specific. merchandise Linking and Embedding (OLE). After Linking one cellular from one report (report a million) to a different (report 2), once you regulate the cellular in report a million, it is going to alter in report 2. seem at Excel help, seek for OLE. attempt this easy occasion: Open one excel report (report a million), then open a 2d one (report 2). Now enter ABC in report a million cellular A1, choose A1 and click reproduction, now on report 2 click A1 and Paste specific, Paste link. it is for Excel 2007.