Help working between two worksheets
 

I am farely new to Excel still and need some help.
I am doing finances and have three worksheets dividing up a month. I then
have another worksheet for the months totals.
Each worksheet has it's own total columns but I want to be able to add the
three pages of totals for each row and put that total on the fourth
worksheet. Everyone with me?? Confusing but it's slowly getting there.
I hope someone can help me.
Thank you

Help working between two worksheets
 

For better answers specific to your sheets' names/layout/detail
perhaps you could upload your sample (desensitised)?

You can use this "easy-to-use" free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here in your reply
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"MelSmith" wrote in message
...
I am farely new to Excel still and need some help.
I am doing finances and have three worksheets dividing up a month. I then
have another worksheet for the months totals.
Each worksheet has it's own total columns but I want to be able to add the
three pages of totals for each row and put that total on the fourth
worksheet. Everyone with me?? Confusing but it's slowly getting there.
I hope someone can help me.
Thank you

Help working between two worksheets
 

Hope this worked for you. Never used that before.
Note: Worksheets 1,2,3 daily income and expenditure worksheets. Each column
and row have their won totals. I want to be able to put a sum on worksheet
4's total column that will add up the totals of worksheet 1,2,3's rows and
columns.

http://freefilehosting.net/download/44g14

"Max" wrote:

For better answers specific to your sheets' names/layout/detail
perhaps you could upload your sample (desensitised)?

You can use this "easy-to-use" free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here in your reply
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"MelSmith" wrote in message
...
I am farely new to Excel still and need some help.
I am doing finances and have three worksheets dividing up a month. I then
have another worksheet for the months totals.
Each worksheet has it's own total columns but I want to be able to add the
three pages of totals for each row and put that total on the fourth
worksheet. Everyone with me?? Confusing but it's slowly getting there.
I hope someone can help me.
Thank you

Help working between two worksheets
 

Keep it simple ..

Since all your sheets are 99.9% identically structured
Just use link formulas to pick up the row totals from each of Sheet1/2/3,

In Sheet4,
In C6: =Sheet1!W6
Copy down to C8

In E6: =Sheet2!W6
Copy down to E8

In G6: =Sheet3!Y6
Copy down to G8

The above completes it for your Income section

You could then copy the top row, ie copy C6:G6, and paste it below for the
other rows for the rest of the items for all the other sections
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"MelSmith" wrote:
Hope this worked for you. Never used that before.
Note: Worksheets 1,2,3 daily income and expenditure worksheets. Each column
and row have their won totals. I want to be able to put a sum on worksheet
4's total column that will add up the totals of worksheet 1,2,3's rows and
columns.

http://freefilehosting.net/download/44g14

Help working between two worksheets
 

You are a very clever man...OK. I got the income part of it and it toals
beautifully. Thanks. Now I don't understand the rest of it. I can use the
same method as the income section and that works but what are you saying when
you say copy c6:g6?

"Max" wrote:

Keep it simple ..

Since all your sheets are 99.9% identically structured
Just use link formulas to pick up the row totals from each of Sheet1/2/3,

In Sheet4,
In C6: =Sheet1!W6
Copy down to C8

In E6: =Sheet2!W6
Copy down to E8

In G6: =Sheet3!Y6
Copy down to G8

The above completes it for your Income section

You could then copy the top row, ie copy C6:G6, and paste it below for the
other rows for the rest of the items for all the other sections
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"MelSmith" wrote:
Hope this worked for you. Never used that before.
Note: Worksheets 1,2,3 daily income and expenditure worksheets. Each column
and row have their won totals. I want to be able to put a sum on worksheet
4's total column that will add up the totals of worksheet 1,2,3's rows and
columns.

http://freefilehosting.net/download/44g14

Help working between two worksheets
 

Good to hear you got it working

.. what are you saying when you say copy c6:g6?
It was just a shortcut way to facilitate formula propagation to the rest of
the items below, w/o having to re-do the links & filldown like what was done
for the income section. Since C6:G6 would already house the 3 formulated link
cells within (the in-between blank cells doesn't matter), its convenient just
to copy that range and do the pastes below for the rest of the items. When
you paste, the 3 formulas will get copied correctly to each line, ie the cell
refs will change relatively, correctly, as your layout is fortunately
identical structure

Btw, pl press the YES buttons (like the ones below) in all responses which
help to answer your queries. Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"MelSmith" wrote:
You are a very clever man...OK. I got the income part of it and it toals
beautifully. Thanks. Now I don't understand the rest of it. I can use the
same method as the income section and that works but what are
you saying when you say copy c6:g6?