summary page of many worksheets

  • Thread starter frustrated scotstman
  • Start date
F

frustrated scotstman

How can I summarize the input values of one cell in many worksheets, other
than referencing them individually. I.e. A summary page listing the values
in all worksheet cell h8, for example.
 
M

Max

Use INDIRECT to quickly frame it up ..

List the sheetnames in A2 down, eg in A2: Sheet2
List the cell references in B1 across, eg in B1: H8

Then place in B2: =INDIRECT("'"&$A2&"'!"&B$1)
Copy B2 across/fill down as required to populate the summary
 

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

link few worksheets in one summary sheet 1
formulae in excel worksheets 4
Referrences of multiple cells from one worksheet to another 3
Copy Cells from multiple Worksheets in same workbook. 2
Excel Count If Formula Question 1
Totalling a group of worksheets 3
Linking data from worksheet to worksheet 6
Reference worksheets in ascending order 1

Top