How do I see detail of summed cells
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. |
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! ============================================== "Greg Chapman" <Greg wrote in message ... 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. |
All times are GMT +1. The time now is 03:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com