summarize

[Josue]

I am working in excel 2007 and am working in a worksheet with many sheets, but for this example I am just using 3 sheets. In the first one I have the data for january, in the second one data for february and in the third one I need to summarize with this data for january and february. How can I so if I have many data and many sheets. Thanks in advance for any help.

<table border="0" cellpadding="0" cellspacing="0" width="240"><col style="width: 60pt;" span="3" width="80"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 60pt;" height="20" width="80">
</td> <td style="width: 60pt;" width="80">
</td> <td style="width: 60pt;" width="80">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">sheet1
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>January</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Cash</td> <td align="right">10</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Banks</td> <td align="right">23</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Inventory</td> <td align="right">33</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> </tbody></table>sheet2
<table border="0" cellpadding="0" cellspacing="0" width="160"><col style="width: 60pt;" span="2" width="80"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 60pt;" height="20" width="80">
</td> <td style="width: 60pt;" width="80">February</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Cash</td> <td align="right">23</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Banks</td> <td align="right">44</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Inventory</td> <td align="right">56</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">fixed assets</td> <td align="right">34</td> </tr> </tbody></table>
sheet 3

<table border="0" cellpadding="0" cellspacing="0" width="240"><col style="width: 60pt;" span="3" width="80"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 60pt;" height="20" width="80">
</td> <td style="width: 60pt;" width="80">January</td> <td style="width: 60pt;" width="80">February</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Cash</td> <td align="right">10</td> <td align="right">23</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Banks</td> <td align="right">23</td> <td align="right">44</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Inventory</td> <td align="right">33</td> <td align="right">56</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">fixed assets</td> <td>
</td> <td align="right">34</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> </tbody></table>

 

[Robert Mika]

Is the layout of the values as same for all sheets?
Do you want to summarize or bring all data into one sheet?

 

[Robert Mika]

On second thought:

Look at this:
Your data in your sheet starts in B2 and the name of the Sheet are "january","february"....

Summary table:

<TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=256><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20 width=64></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=64></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=64>january</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl65 width=64>february</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=20>b2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>Cash</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl68>33</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=20>b3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>Banks</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>23</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl68>44</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 height=21>b4</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70>Inventory</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70>33</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl71>56</TD></TR></TBODY></TABLE>

Formula in C2:
=INDIRECT(C$1&"!"&$A2)
Copy down and accros

 

[Josue]

Thank you for your replay; however, it is not working. I wrote down the formula and it is giving me an error as follows:

<table border="0" cellpadding="0" cellspacing="0" width="243"><col style="width:60pt" width="80"> <col style="mso-width-source:userset;mso-width-alt:3035;width:62pt" width="83"> <col style="width:60pt" width="80"> <tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:60pt" height="20" width="80">
</td> <td style="width:62pt" width="83">january</td> <td style="width:60pt" width="80">february</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">cash</td> <td align="center">#¡REF!</td> <td align="center">#¡REF!</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Banks</td> <td align="center">#¡REF!</td> <td align="center">#¡REF!</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Inventory</td> <td align="center">#¡REF!</td> <td align="center">#¡REF!</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">fixed assets</td> <td align="center">#¡REF!</td> <td align="center">#¡REF!</td> </tr> </tbody></table>
What I really want is to bring the data from sheet one and two to sheet three and it may not be the same layout for every sheet I use because sometimes I have different accounts.

 

[Robert Mika]

The first and second columns in the small table here are columns A and B.
You need to add the "b2","b3" and "b4" into column A.
Your sheets must have the months names.

If your data have difffrent layout each time you will need to :
-adjust them to match on all sheets
or post them here to see if there is anothr way to help you