ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linking Cells from different sheets (https://www.excelbanter.com/excel-discussion-misc-queries/145424-linking-cells-different-sheets.html)

JasonG TX

Linking Cells from different sheets
 
Here is what I am trying to do. I have 6 total spreadsheet, 5 that could be
considered 'child' spreadsheets (we will call them SheetA, SheetB, etc) and 1
'parent' sheet (Sheet1). Each 'child' sheet will contain 50 or more rows and
columns of data, including a sum at the end. There will be additions and
deletions of rows on a regular basis.

The 'parent' sheet, (Sheet1) will have 6 tabs on it, one that displays an
constantly updating copy of each 'child' sheet, and then the 6th tab will be
a cumulative of all of the previous tabs, one on top of the other. Then at
the bottom of that sheet I would like a sum of all the above numbers.

To top it off, on each the child sheets I would like a continuously updated
copy of the 6th tab (totals) of the parent sheet. Is this at all possibe?

Don Guillett

Linking Cells from different sheets
 
Please learn to use the proper terminology and then state your problem.
Otherwise it is sometimes confusing.
a file is called a workBOOK and it has workSHEETS.

--
Don Guillett
SalesAid Software

"JasonG TX" <JasonG
wrote in message
...
Here is what I am trying to do. I have 6 total spreadsheet, 5 that could
be
considered 'child' spreadsheets (we will call them SheetA, SheetB, etc)
and 1
'parent' sheet (Sheet1). Each 'child' sheet will contain 50 or more rows
and
columns of data, including a sum at the end. There will be additions and
deletions of rows on a regular basis.

The 'parent' sheet, (Sheet1) will have 6 tabs on it, one that displays an
constantly updating copy of each 'child' sheet, and then the 6th tab will
be
a cumulative of all of the previous tabs, one on top of the other. Then
at
the bottom of that sheet I would like a sum of all the above numbers.

To top it off, on each the child sheets I would like a continuously
updated
copy of the 6th tab (totals) of the parent sheet. Is this at all possibe?




All times are GMT +1. The time now is 02:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com