Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Data from Multiple Worksheets
Is there a way to link data from multiple worksheets in the same workbook to
a single worksheet used as a "running total" also in the same workbook? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Data from Multiple Worksheets
Something like this in say, Sheet4's B2:
=SUM(Sheet1:Sheet3!A1) will return the sum of what's in A1 in Sheets 1, 2 & 3 whe Sheets 1 & 3 are the "bookend" sheets Sheet2 is assumed placed in-between Sheets 1 & 3 Sheet4 (the "summary" sheet) is assumed not within Sheets 1 & 3 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Danedel" wrote in message ... Is there a way to link data from multiple worksheets in the same workbook to a single worksheet used as a "running total" also in the same workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
same data multiple worksheets | Excel Discussion (Misc queries) | |||
Data Validation drop down for multiple worksheets | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
How do I display data from multiple worksheets in a summary sheet. | Excel Discussion (Misc queries) | |||
How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions |