PC Review


Reply
Thread Tools Rate Thread

Copy formula from various sheets

 
 
Roger Dodger
Guest
Posts: n/a
 
      21st Sep 2010
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


 
Reply With Quote
 
 
 
 
Don Guillett Excel MVP
Guest
Posts: n/a
 
      21st Sep 2010
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."
 
Reply With Quote
 
zvkmpw
Guest
Posts: n/a
 
      22nd Sep 2010
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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy sheets for formula afdmello Microsoft Excel Discussion 1 14th Oct 2009 03:40 PM
copy data between sheets, but not the formula minxy11 Microsoft Excel Worksheet Functions 1 28th Mar 2006 03:18 PM
Re: Copy formula for ranges from diff sheets icestationzbra Microsoft Excel Misc 0 21st Sep 2004 06:27 PM
Copy formula for ranges from diff sheets Bernie Microsoft Excel Misc 1 21st Sep 2004 01:25 PM
Copy relative formula across sheets mmwilcox Microsoft Excel Misc 5 7th May 2004 12:40 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:18 AM.