Find values from cells in multiple sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook containing several sheets , all of which use identical
formats - 12 sheets, one for each month of the year.
I want a summary sheet with the values of the same cell address in each sheet
For example, Summary!A5 = Sheet1!A10
A6 = Sheet2!A10 and so on
Is there an inbuilt Excel function or simple way to do this.
 
One way:

Enter in A5:

=INDIRECT("Sheet"&ROW(A1)&"!A10")

And copy down as needed.
 
In Summary!A5 enter =INDIRECT("Sheet"&ROW(A1)&"!A10") to get value from
Sheet1!A10
Copy to A6 from Sheet2, etc
best wishes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif contains a word in a reference cell 3
Sum across sheets based on a condition 3
summary values across worksheets within the same workbook 2
Adding multiple cells meeting criteria 4
Function To Add across Multiple Sheets with a Twist 9
Macro for summarizing multiple sheets 1
Vlookup in multiple sheets 2
Linking to other worksheets 3

Back
Top