software

I am going to try to explain what I need to do. I created a new group of
spread sheets. Each sheet representing a Month, and each month has several
groups, tallied by day. At the end of each month I have created a quot;Jan Totalquot;
column to talley each group. I then made a sheet to represent each group of
data for all 12 months.
What I want to do is incert the Total of each group for each month in the
corresponding group on the Work Sheet representing all 12 months.

I have tried =January!AG2, =January! to represent the sheet, and AG2 for the
total of that group. It does not work, and I have tried several other
formulas to no avail. Can someone help me?


can you send me sample data like that sheet. then i would return to by
making it what you required.
and please explain your question in that workbook too.
send me at:Richard Deldonna Wrote:
gt; I am going to try to explain what I need to do. I created a new group
gt; of
gt; spread sheets. Each sheet representing a Month, and each month has
gt; several
gt; groups, tallied by day. At the end of each month I have created a quot;Jan
gt; Totalquot;
gt; column to talley each group. I then made a sheet to represent each
gt; group of
gt; data for all 12 months.
gt; What I want to do is incert the Total of each group for each month in
gt; the
gt; corresponding group on the Work Sheet representing all 12 months.
gt;
gt; I have tried =January!AG2, =January! to represent the sheet, and AG2
gt; for the
gt; total of that group. It does not work, and I have tried several other
gt; formulas to no avail. Can someone help me?--
starguy
------------------------------------------------------------------------
starguy's Profile: www.excelforum.com/member.php...oamp;userid=32434
View this thread: www.excelforum.com/showthread...hreadid=523836
can you send me sample data like that sheet. then i would return to by
making it what you required.
and please explain your question in that workbook too.
send me at:Richard Deldonna Wrote:
gt; I am going to try to explain what I need to do. I created a new group
gt; of
gt; spread sheets. Each sheet representing a Month, and each month has
gt; several
gt; groups, tallied by day. At the end of each month I have created a quot;Jan
gt; Totalquot;
gt; column to talley each group. I then made a sheet to represent each
gt; group of
gt; data for all 12 months.
gt; What I want to do is incert the Total of each group for each month in
gt; the
gt; corresponding group on the Work Sheet representing all 12 months.
gt;
gt; I have tried =January!AG2, =January! to represent the sheet, and AG2
gt; for the
gt; total of that group. It does not work, and I have tried several other
gt; formulas to no avail. Can someone help me?--
starguy
------------------------------------------------------------------------
starguy's Profile: www.excelforum.com/member.php...oamp;userid=32434
View this thread: www.excelforum.com/showthread...hreadid=523836
can you send me sample data like that sheet. then i would return to by
making it what you required.
and please explain your question in that workbook too.
send me at:Richard Deldonna Wrote:
gt; I am going to try to explain what I need to do. I created a new group
gt; of
gt; spread sheets. Each sheet representing a Month, and each month has
gt; several
gt; groups, tallied by day. At the end of each month I have created a quot;Jan
gt; Totalquot;
gt; column to talley each group. I then made a sheet to represent each
gt; group of
gt; data for all 12 months.
gt; What I want to do is incert the Total of each group for each month in
gt; the
gt; corresponding group on the Work Sheet representing all 12 months.
gt;
gt; I have tried =January!AG2, =January! to represent the sheet, and AG2
gt; for the
gt; total of that group. It does not work, and I have tried several other
gt; formulas to no avail. Can someone help me?--
starguy
------------------------------------------------------------------------
starguy's Profile: www.excelforum.com/member.php...oamp;userid=32434
View this thread: www.excelforum.com/showthread...hreadid=523836Tanks for replying Starguy, but I found what I was looking for by creating a
new work sheet, and copy the cells I want copied, and pasting special on to
the new blank work sheet.

Thank you for getting back so soon.

gt;
gt; can you send me sample data like that sheet. then i would return to by
gt; making it what you required.
gt; and please explain your question in that workbook too.
gt; send me at:
gt;
gt;
gt; Richard Deldonna Wrote:
gt; gt; I am going to try to explain what I need to do. I created a new group
gt; gt; of
gt; gt; spread sheets. Each sheet representing a Month, and each month has
gt; gt; several
gt; gt; groups, tallied by day. At the end of each month I have created a quot;Jan
gt; gt; Totalquot;
gt; gt; column to talley each group. I then made a sheet to represent each
gt; gt; group of
gt; gt; data for all 12 months.
gt; gt; What I want to do is incert the Total of each group for each month in
gt; gt; the
gt; gt; corresponding group on the Work Sheet representing all 12 months.
gt; gt;
gt; gt; I have tried =January!AG2, =January! to represent the sheet, and AG2
gt; gt; for the
gt; gt; total of that group. It does not work, and I have tried several other
gt; gt; formulas to no avail. Can someone help me?
gt;
gt;
gt; --
gt; starguy
gt; ------------------------------------------------------------------------
gt; starguy's Profile: www.excelforum.com/member.php...oamp;userid=32434
gt; View this thread: www.excelforum.com/showthread...hreadid=523836
gt;
gt;