Hi again,

Can someone tell me if there is an easy way to copy a cell amount into a
grand total.

i.e.:
sheet 1 = Jan-2010
Sheet 2 = Feb-2010
Sheet 3 = Mar-2010 etc.
Each sheet has 5 totals (one for each department) these are A5-E5
Sheet 13 has the totals from each month and provides the data for graphs and
analysis.

One thing that I might mention is that sheet 13 enters the data into G6-G11
through to S6-S11 . I am not sure if this is a problem because of the
different direction,e.g. column instead of row.

A shortcut would make life much easier and give my poor gingers a needed
rest.

Thanks in advance
Kevin

On Sep 21, 2:16*am, "Roger Dodger" <gtsmonaro...@bigpond.com> wrote:
> Hi again,
>
> Can someone tell me if there is an easy way to copy a cell amount into a
> grand total.
>
> i.e.:
> sheet 1 = Jan-2010
> Sheet 2 = Feb-2010
> Sheet 3 = Mar-2010 etc.
> Each sheet has 5 totals (one for each department) these are A5-E5
> Sheet 13 has the totals from each month and provides the data for graphs and
> analysis.
>
> One thing that I might mention is that sheet 13 enters the data into G6-G11
> through to S6-S11 . I am not sure if this is a problem because of the
> different direction,e.g. column instead of row.
>
> A shortcut would make life much easier and give my poor gingers a needed
> rest.
>
> Thanks in advance
> Kevin

Hard to visualize your file so
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

Maybe this will help get started.

In my example, I put Jan, Feb, Mar, ... in sheet13 cells G1, H1,
I1, ...

In G6, I put
=INDIRECT("'"&G$1&"-2010'!"&CHAR(59+ROW())&5)

Then I copied G6 rightward to R6.

Then I selected G6:R6 and copied down to row 10.

The table G6:R10 copies the total from the other sheets, if I
understand the problem correctly.

(Actually, I only did Jan-Mar in the interest of time.)

Modify to suit.