i have 7 worksheets ( identical in size ) - for different days and I want to
create a sumarry sheet i.e. cell B7 in the summary sheet to sum cells C5
from each worksheet ( in the same workbook ). Then having five workbooks ( or
worksheets )i.e.five weeks , to summarize them in one grand summary book (
monthly ) and then the final move is to make the year book ( 12 month in one
)Please help . I tried =sum( sheet1:sheet7!B7) in sheet10 cell K4 and it did
not work