Unless I misunderstand your question, couldn't you link (and sum) the sheets
using :
=Sheet1!A1+Sheet2!A1 etc etc
=Jan!a1+Feb!a1+Mar!a1
I hope that helps?
"Loi" wrote in message
...
Hi,
I have a workbook which has 12 sheets for 12 months (Jan,
Feb, March.........
Each sheet has 7 colums.
Please show me how Can I create a summary sheet which will
have 7*12=84 colums.
I think that 1)the summary sheet won't have enough room
for 84 colums 2)I realy don't know how to link all sheets
as the same time.
I like to set up the links so that when I enter data in
Jan sheet, these data will also appear on summary sheet.
Thank you
Loi
|