How do I see detail of summed cells

[Guest]

I have a file with a large number of tabs--about 80--that sum to a lead
sheet. I want to be able to view, by tab, the values in a given cell from the
lead sheet. So for instance, in cell C30 on the lead sheet I should be able
to get a subview of all the numbers in the various tabs rolling into that
cell (with the tab identified). Otherwise, I must go tab by tab to verify
each value, a time consuming process when you have hundreds of cells that
must be checked over 80 tabs. Thanks.

 

[RagDyer]

Are you saying that you want to use 80 rows of the "lead" sheet to display
the individual particular cell contents of 80 sheets?

If the sheets are named with the default XL designation,
AND, the *same* cell is the particular cell that's summed,
You could try this, in say C31, and drag down for 80 rows:

=INDIRECT("Sheet"&ROW(A1)&"!C30")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a file with a large number of tabs--about 80--that sum to a lead
sheet. I want to be able to view, by tab, the values in a given cell from
the
lead sheet. So for instance, in cell C30 on the lead sheet I should be able
to get a subview of all the numbers in the various tabs rolling into that
cell (with the tab identified). Otherwise, I must go tab by tab to verify
each value, a time consuming process when you have hundreds of cells that
must be checked over 80 tabs. Thanks.