Thread: Summary sheet
View Single Post
  #2   Report Post  
Carl Jarvis
 
Posts: n/a
Default

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