Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking cells between sheets | Excel Worksheet Functions | |||
Linking cells between sheets | Excel Worksheet Functions | |||
Linking cells between sheets | Excel Worksheet Functions | |||
Linking chart cells between sheets | Excel Discussion (Misc queries) | |||
Need Help Linking Sheets | Excel Discussion (Misc queries) |