sharing totals between worksheets

Max · 09-05-2005, 11:05 PM

Assuming the sheets are named:
Sheet1, ... Sheet4

In Sheet4
------------
Put in B3: =IF(Sheet1!J33="","",Sheet1!J33)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"~*~ Twinkle~*~" <~*~ Twinkle~*~@discussions.microsoft.com> wrote in message
news:D8355C47-C45E-4B41-9313-967FF2483124@microsoft.com...
> Hi, HELP! I am trying to create a worksheet to balance our household
income
> and expenses. What I need to do is take a running total from one worksheet
> and have it automatically reflect changes in another worksheet. I don't
know
> the proper terms for this action. So to try spell it out as clearly as I
can:
>
> 1 workbook, 4 worksheets.
>
> Worksheet 1 has a running total in cell J33 (reflecting a total of all our
> monthly payments and loans)
>
> What I would like to do is have this figure in Worksheet 4 in cell B3
> reflecting any changes made in Worksheet 1 to the original total.
>
> Any help from anyone would be GREATLY appreciated! Thanks in advnace!

Max · 09-06-2005, 12:05 AM

Assuming the sheets are named:
Sheet1, ... Sheet4

In Sheet4
------------
Put in B3: =IF(Sheet1!J33="","",Sheet1!J33)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"~*~ Twinkle~*~" <~*~ Twinkle~*~@discussions.microsoft.com> wrote in message
news:D8355C47-C45E-4B41-9313-967FF2483124@microsoft.com...
> Hi, HELP! I am trying to create a worksheet to balance our household
income
> and expenses. What I need to do is take a running total from one worksheet
> and have it automatically reflect changes in another worksheet. I don't
know
> the proper terms for this action. So to try spell it out as clearly as I
can:
>
> 1 workbook, 4 worksheets.
>
> Worksheet 1 has a running total in cell J33 (reflecting a total of all our
> monthly payments and loans)
>
> What I would like to do is have this figure in Worksheet 4 in cell B3
> reflecting any changes made in Worksheet 1 to the original total.
>
> Any help from anyone would be GREATLY appreciated! Thanks in advnace!

Max · 09-06-2005, 01:05 AM

Assuming the sheets are named:
Sheet1, ... Sheet4

In Sheet4
------------
Put in B3: =IF(Sheet1!J33="","",Sheet1!J33)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"~*~ Twinkle~*~" <~*~ Twinkle~*~@discussions.microsoft.com> wrote in message
news:D8355C47-C45E-4B41-9313-967FF2483124@microsoft.com...
> Hi, HELP! I am trying to create a worksheet to balance our household
income
> and expenses. What I need to do is take a running total from one worksheet
> and have it automatically reflect changes in another worksheet. I don't
know
> the proper terms for this action. So to try spell it out as clearly as I
can:
>
> 1 workbook, 4 worksheets.
>
> Worksheet 1 has a running total in cell J33 (reflecting a total of all our
> monthly payments and loans)
>
> What I would like to do is have this figure in Worksheet 4 in cell B3
> reflecting any changes made in Worksheet 1 to the original total.
>
> Any help from anyone would be GREATLY appreciated! Thanks in advnace!

Max · 09-06-2005, 02:05 AM

Assuming the sheets are named:
Sheet1, ... Sheet4

In Sheet4
------------
Put in B3: =IF(Sheet1!J33="","",Sheet1!J33)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"~*~ Twinkle~*~" <~*~ Twinkle~*~@discussions.microsoft.com> wrote in message
news:D8355C47-C45E-4B41-9313-967FF2483124@microsoft.com...
> Hi, HELP! I am trying to create a worksheet to balance our household
income
> and expenses. What I need to do is take a running total from one worksheet
> and have it automatically reflect changes in another worksheet. I don't
know
> the proper terms for this action. So to try spell it out as clearly as I
can:
>
> 1 workbook, 4 worksheets.
>
> Worksheet 1 has a running total in cell J33 (reflecting a total of all our
> monthly payments and loans)
>
> What I would like to do is have this figure in Worksheet 4 in cell B3
> reflecting any changes made in Worksheet 1 to the original total.
>
> Any help from anyone would be GREATLY appreciated! Thanks in advnace!

Max · 09-06-2005, 03:05 AM

Assuming the sheets are named:
Sheet1, ... Sheet4

In Sheet4
------------
Put in B3: =IF(Sheet1!J33="","",Sheet1!J33)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"~*~ Twinkle~*~" <~*~ Twinkle~*~@discussions.microsoft.com> wrote in message
news:D8355C47-C45E-4B41-9313-967FF2483124@microsoft.com...
> Hi, HELP! I am trying to create a worksheet to balance our household
income
> and expenses. What I need to do is take a running total from one worksheet
> and have it automatically reflect changes in another worksheet. I don't
know
> the proper terms for this action. So to try spell it out as clearly as I
can:
>
> 1 workbook, 4 worksheets.
>
> Worksheet 1 has a running total in cell J33 (reflecting a total of all our
> monthly payments and loans)
>
> What I would like to do is have this figure in Worksheet 4 in cell B3
> reflecting any changes made in Worksheet 1 to the original total.
>
> Any help from anyone would be GREATLY appreciated! Thanks in advnace!

~*~ Twinkle~*~ · 09-06-2005, 05:05 AM

Hi, HELP! I am trying to create a worksheet to balance our household income
and expenses. What I need to do is take a running total from one worksheet
and have it automatically reflect changes in another worksheet. I don't know
the proper terms for this action. So to try spell it out as clearly as I can:

1 workbook, 4 worksheets.

Worksheet 1 has a running total in cell J33 (reflecting a total of all our
monthly payments and loans)

What I would like to do is have this figure in Worksheet 4 in cell B3
reflecting any changes made in Worksheet 1 to the original total.

Any help from anyone would be GREATLY appreciated! Thanks in advnace!

Max · 09-06-2005, 05:05 AM

Assuming the sheets are named:
Sheet1, ... Sheet4

In Sheet4
------------
Put in B3: =IF(Sheet1!J33="","",Sheet1!J33)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"~*~ Twinkle~*~" <~*~ Twinkle~*~@discussions.microsoft.com> wrote in message
news:D8355C47-C45E-4B41-9313-967FF2483124@microsoft.com...
> Hi, HELP! I am trying to create a worksheet to balance our household
income
> and expenses. What I need to do is take a running total from one worksheet
> and have it automatically reflect changes in another worksheet. I don't
know
> the proper terms for this action. So to try spell it out as clearly as I
can:
>
> 1 workbook, 4 worksheets.
>
> Worksheet 1 has a running total in cell J33 (reflecting a total of all our
> monthly payments and loans)
>
> What I would like to do is have this figure in Worksheet 4 in cell B3
> reflecting any changes made in Worksheet 1 to the original total.
>
> Any help from anyone would be GREATLY appreciated! Thanks in advnace!