Linking Multiple Tabs

B

Big Ben

Hi guys,

I have a workbook with 195 tabs that need to be linked into a summar
sheet. Each tab is IDENTICAL so it is simply a matter of summing eac
cell in the respective tabs to the summary sheet. It will be ver
tedious having to link 195 tabs into the summary sheet (the summar
sheet needs to link about 30 rows too) !!! Is there a way to lin
these sheets without having to manually go through and link the 19
tabs?? Any help would be greatly appreciated!

Thanks.

Be
 
R

rbanks

I assume you're trying to sum up all 195 tabs. If this is the case, g
to your summary tab and the cell reference of the 1st cell you wan
summed (say C10).

Enter formula =SUM('Sheet1:Sheet195'!C10)

Then simply copy the formula to all cell that you want summed.

NOte: This sums a range of sheets, so you can't have any sheets tha
aren't part of the sum within the range
 
R

Ron de Bruin

so it is simply a matter of summing

You can do this

Add two dummy sheets(empty sheets)with the name start as the first sheet
and one with the name end as the last sheet of your workbook.
this are empty sheets!!!

All worksheets between these sheets will be sum
with this formula

=SUM(start:end!B2)
 
D

Don Guillett

If you mean that you have a figure in cell a1 in each worksheet (tab) then
=sum(sheet1:sheet195!a1) will sum it up.
 
B

Big Ben

That works perfectly. Thanks so much for your help. I have run accros
another problem now. In the same spreadsheet, I have a price that i
the same across all tabs. However, I would like have the ability t
change this price through the master tab (summary sheet) so that when
change the price on the master tab, each individual sheet will tak
this change into account. I realize that it is possible to go throug
and link the individual tabs to the master tab, but this seems ver
tedious. ie. say in sheet 1 in cell C10 I have ='Master!C10. Is ther
a way to get this formula in without having to manually go through t
link each tab?

Thanks,

Be
 
R

rbanks

Take your formula in c10 of sheet one,

[edit][copy],

select all tabs Sheet2 - Sheet195, put the cursor in cell c10 an
[paste]
 
B

Big Ben

Thanks Rbanks,

I really appreciate your help. Pasting to all sheets worked with n
problems. Thanks again for your help!

Be
 
Top