Prev: How do I set up a file to automatically save on exit?
Next: How do I stop the screen from jumping
From: Millie on 15 May 2010 08:08
Hi

I can do basic formulas in Excel 2007 like adding subtracting etc. Here's
what I want to do and I would appreciate any help in achievingit:

In worksheet 1, I want to add up money i spend. In worksheet 2, i want to
show my budget total and then see the reducing total as I enter amounts in
worksheet 1. Can anyone help?
--
Millie
From: trip_to_tokyo on 15 May 2010 08:50
EXCEL 2007

I have just put up a file for you at:-

http://www.pierrefondes.com/

Item number 106.

This is one way in which you might do it.

If you add in extra items into Money_Spent columns A and B you will see what
you have got left in Budget cell C2.

If my comments have helped please hit Yes.

Thanks.




In worksheet 1, I want to add up money i spend.

In worksheet 2, i want to show my budget total and then see the reducing
total as I enter amounts in worksheet 1.
From: Millie on 15 May 2010 09:08
Hi Perfect. But how did you link the two workseets? Can you guide me through
the steps?
--
Millie


"trip_to_tokyo" wrote:

> EXCEL 2007
>
> I have just put up a file for you at:-
>
> http://www.pierrefondes.com/
>
> Item number 106.
>
> This is one way in which you might do it.
>
> If you add in extra items into Money_Spent columns A and B you will see what
> you have got left in Budget cell C2.
>
> If my comments have helped please hit Yes.
>
> Thanks.
>
>
>
>
> In worksheet 1, I want to add up money i spend.
>
> In worksheet 2, i want to show my budget total and then see the reducing
> total as I enter amounts in worksheet 1.
From: trip_to_tokyo on 15 May 2010 09:17
Just look at the formulas in the cells; you should be OK from there.

"Millie" wrote:

> Hi Perfect. But how did you link the two workseets? Can you guide me through
> the steps?
> --
> Millie
>
>
> "trip_to_tokyo" wrote:
>
> > EXCEL 2007
> >
> > I have just put up a file for you at:-
> >
> > http://www.pierrefondes.com/
> >
> > Item number 106.
> >
> > This is one way in which you might do it.
> >
> > If you add in extra items into Money_Spent columns A and B you will see what
> > you have got left in Budget cell C2.
> >
> > If my comments have helped please hit Yes.
> >
> > Thanks.
> >
> >
> >
> >
> > In worksheet 1, I want to add up money i spend.
> >
> > In worksheet 2, i want to show my budget total and then see the reducing
> > total as I enter amounts in worksheet 1.
From: Millie on 15 May 2010 09:24
Hi thanks. I understand now!
--
Millie


"trip_to_tokyo" wrote:

> Just look at the formulas in the cells; you should be OK from there.
>
> "Millie" wrote:
>
> > Hi Perfect. But how did you link the two workseets? Can you guide me through
> > the steps?
> > --
> > Millie
> >
> >
> > "trip_to_tokyo" wrote:
> >
> > > EXCEL 2007
> > >
> > > I have just put up a file for you at:-
> > >
> > > http://www.pierrefondes.com/
> > >
> > > Item number 106.
> > >
> > > This is one way in which you might do it.
> > >
> > > If you add in extra items into Money_Spent columns A and B you will see what
> > > you have got left in Budget cell C2.
> > >
> > > If my comments have helped please hit Yes.
> > >
> > > Thanks.
> > >
> > >
> > >
> > >
> > > In worksheet 1, I want to add up money i spend.
> > >
> > > In worksheet 2, i want to show my budget total and then see the reducing
> > > total as I enter amounts in worksheet 1.
 |  Next  |  Last
Pages: 1 2
Prev: How do I set up a file to automatically save on exit?
Next: How do I stop the screen from jumping