Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locate and delete specific cells | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) |