Copy formula from various sheets

  • Thread starter Thread starter Roger Dodger
  • Start date Start date
R

Roger Dodger

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
 
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
Click to expand...

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.
 
Back
Top