Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
gambinijr
 
Posts: n/a
Default Linking sheets to a summary sheet in workbook

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
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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

"gambinijr" wrote:

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

  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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 wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #4   Report Post  
gambinijr
 
Posts: n/a
Default

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" wrote:

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

"gambinijr" wrote:

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

  #5   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
did not receive any email. You may try again :-)

--
Regards
Frank Kabel
Frankfurt, Germany

gambinijr wrote:
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" wrote:

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

"gambinijr" wrote:

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
linking cell value in one workbook to a cell in another workbook Jig Bhakta Links and Linking in Excel 1 January 20th 05 07:12 PM
Linking two sheets in different books Glenn Mulno Links and Linking in Excel 8 January 6th 05 12:13 AM
Linking to an Entire Sheet Chaplain Doug Links and Linking in Excel 2 December 24th 04 08:39 AM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 08:43 AM
Updating sheets within a workbook Mike R Excel Discussion (Misc queries) 1 December 4th 04 06:25 AM


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"