Linking sheets to a summary sheet in workbook

[gambinijr]

Can anyone help me with linking multiple sheets to a summary page in a
workbook?

I have multiple sheets - one for each day. Each sheet is identical. They
all tie into a summary sheet. The problem is copying and pasting on the
summary sheet. I cannot figure out to program excel to change to the next
sheet for me.

For example in summary cell B4 i have the following (+'12-01-04'!C65) in
summary sheet b5 I have (+'12-02-04'c65)

My problem is I have hundreds of sheets and copying and pasting down column
b in the summary sheet does not switch to the different individual sheets.
Is there a way to make excel do this automatically? I have used absolute
cell references and then edited each cell, however that is very tedious.

My other problem is that when I have to change the shetts in the workbook, I
have to keep them identical. Is there a way to make one change to qa sheet
and have it affect all other sheets except the summary sheet?

Thanks

 

[Frank Kabel]

Hi
try the following formula in B4:
=INDIRECT("'" & TEXT(DATE(2004,12,ROW()-ROW($B$3)),"mm-dd-yy") & "'!C65")
and copy this down

 

[Debra Dalgleish]

To change several sheets at once:

Click on the tab of the first sheet you want to change
Scroll through the sheet tabs, until you can see the last tab
Hold the Shift key, and click on the tab of the last sheet

The selected sheets are grouped, and you'll see [Group] at the end of
the name in the Title bar
Make the changes to the active worksheet, and all selected sheets will
be changed

When finished, right-click one of the sheet tabs, and select
Ungroup Sheets

 

[gambinijr]

thanks - i sent you an attached email -- can youlook at the info and see why
that formula is not working.

Thanks your a cool guy to do this forum and help people.

 

[Frank Kabel]

Hi
did not receive any email. You may try again