Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summary sheet
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Loi wrote:
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 Don't worry about the number of columns - an Excel worksheet has 256! |
#4
|
|||
|
|||
Hi,
Did you get the help you needed on this? I have a similar need too. I want to have 7 different sheets updated in a summary sheet. However, instead of having them on different columns, I want them to update the same column within the summary page. Basically, I want them to add rows to the summary sheet. Thanks! Ken -----Original 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Sheet tabs disappear sometimes in Internet Explorer | Excel Discussion (Misc queries) |