Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Data from multiple sheets

I have 30+ sheets in my spreadsheet. I created the formula show below to lookup the data and add it all up in a "summary" sheet. Example below covers just two sheets of my 30+

This works and I get the result, but I am also hoping that there might be a way to reference all sheets without doing it one by one. Relevant data is in the same columns in each sheet.


Posted on Sep 25, 2020 11:26 PM

Reply
Question marked as Top-ranking reply

Posted on Sep 26, 2020 3:43 AM

Hi Birdsville,


You can do this by creating cell addresses for the function INDIRECT to "pull" the data you want to look up.



Formula in E2: "Sheet "&A2&"::Table "&B2&"::"&C2&D2

Formula in F2: INDIRECT(E2)


This is a clunky approach. Perhaps another user will step in with a better method.

Good luck!

Ian.

2 replies
Sort By: 
Question marked as Top-ranking reply

Sep 26, 2020 3:43 AM in response to Birdsville

Hi Birdsville,


You can do this by creating cell addresses for the function INDIRECT to "pull" the data you want to look up.



Formula in E2: "Sheet "&A2&"::Table "&B2&"::"&C2&D2

Formula in F2: INDIRECT(E2)


This is a clunky approach. Perhaps another user will step in with a better method.

Good luck!

Ian.

Reply

Data from multiple sheets

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.