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 "Jan Total"
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:
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 "Jan
Total"
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?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://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:
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 "Jan
Total"
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?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://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:
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 "Jan
Total"
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?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=523836

Tanks 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.


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:
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 "Jan
Total"
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?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=523836