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? |
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? |
All times are GMT +1. The time now is 11:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com