Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 16th 04, 06:57 AM
greg g
 
Posts: n/a
Default linking multiple sheets to a summary sheet

Please help!
I have a workbook that has multiple sheets (one for every day of the week)
that records data in the same place on every sheet (Each day is a copy of a
master sheet - so the cell placements are the same)
My question is 2 part:
1.) Is there a way to link the sheets so that if the format of the sheets
needs to be changed, that I do not have to change every sheet (every sheet
would change to reflect the same master sheet). For instance add a couple
of rows to 12/01/04 sheet and it will add rows to every other sheet.
2.) I summarize the data on a summary sheet for groups of dates. For
example in cell b4 on summary sheet (=+'12-01-04'!c56) Cell b5 on summary
sheet ((=+'12-01-04'!e56) in Cell c4 on summary sheet (=+'12-02-04'!c56)
Cell c5 on summary sheet (=+'12-02-04'!c56) etcetera.
I have used absolute references and pasted down the column then went into
each c ell on the summary sheet and just retyped over the date --- I am
hoping for an easier solution -- any help would be appreciated

  #2   Report Post  
Old December 16th 04, 07:43 AM
Frank Kabel
 
Posts: n/a
Default

Hi
see your other post

"greg g" wrote:

Please help!
I have a workbook that has multiple sheets (one for every day of the week)
that records data in the same place on every sheet (Each day is a copy of a
master sheet - so the cell placements are the same)
My question is 2 part:
1.) Is there a way to link the sheets so that if the format of the sheets
needs to be changed, that I do not have to change every sheet (every sheet
would change to reflect the same master sheet). For instance add a couple
of rows to 12/01/04 sheet and it will add rows to every other sheet.
2.) I summarize the data on a summary sheet for groups of dates. For
example in cell b4 on summary sheet (=+'12-01-04'!c56) Cell b5 on summary
sheet ((=+'12-01-04'!e56) in Cell c4 on summary sheet (=+'12-02-04'!c56)
Cell c5 on summary sheet (=+'12-02-04'!c56) etcetera.
I have used absolute references and pasted down the column then went into
each c ell on the summary sheet and just retyped over the date --- I am
hoping for an easier solution -- any help would be appreciated



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 two sheets in different books Glenn Mulno Links and Linking in Excel 8 January 5th 05 11:13 PM
Linking to an Entire Sheet Chaplain Doug Links and Linking in Excel 2 December 24th 04 07:39 AM
how do i switch between multiple sheets in the same workbook (key. Catalin Excel Discussion (Misc queries) 3 December 16th 04 06:33 PM
HELP -- probably a LOOKUP problem Liz-In-USA Excel Discussion (Misc queries) 3 December 9th 04 12:18 AM
How do I plot data in Excel that is captured on separate sheets; . krwegner Excel Discussion (Misc queries) 0 November 30th 04 05:43 PM


All times are GMT +1. The time now is 11:19 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017