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

Auto populate value from one task to another in MS PROJECT 0
Multiple worksheet summary 4
Link data from Another cell 1
Linking data from worksheet to worksheet 6
Page numbering with Merged Document and IF statements 1
linking worksheets 8
modify all formula references in multiple cells 3
Copy Cells from multiple Worksheets in same workbook. 2

Top