Here is a picture of what i want to do:
http://img.photobucket.com/albums/v1...1/Question.jpg


I want to have the "Account Balance After" value transfered to the
"Account Balance Before" cell below it when I tab down to that row.
I'm new at this stuff and don't know what to put in for the functions
to make this happen.

In C3 put
=D2

You can now fill down the sheet from C3 and from D2 and the formulas will
automatically update and show the values as you make entries into the cells
in column B.


"Black_op51" wrote:

Here is a picture of what i want to do:
http://img.photobucket.com/albums/v1...1/Question.jpg


I want to have the "Account Balance After" value transfered to the
"Account Balance Before" cell below it when I tab down to that row.
I'm new at this stuff and don't know what to put in for the functions
to make this happen.

JLatham (removethis) wrote:
In C3 put
=D2

You can now fill down the sheet from C3 and from D2 and the formulas will
automatically update and show the values as you make entries into the cells
in column B.

ok, i get that but how do i make it so when i "arrow down" row, excel automatically inputs the previous "D" column in the next "C"column?

Say I click on "C10". The previous "D9" which is 0 will be inputed into
"C10". How do i get excel to do that for me?

JLatham (removethis) wrote:
In C3 put
=D2

You can now fill down the sheet from C3 and from D2 and the formulas will
automatically update and show the values as you make entries into the cells
in column B.


Alright i get it. what about the date? so when i click on "A10" it will
store the the current date automatically and wont change when i open it
again

Excel isn't going to automatically do it for you. At least not without
getting a little more advanced than we really need to. Search Excel's Help
for
Fill data in worksheet cells
and choose the topic in the list that appears that has that title, and then
choose the item on the page that appears labeled "Fill formulas into adjacent
cells" and it will show you how to fill the formulas down the sheet as far as
you care to go. As they are set up now, they will show the last calculated
balance down the sheet and as you make entries in column B, the balance will
update on down through the sheet.

If you want to get "fancy" you can change the first formula in cell D2 to
this before filling it on down the sheet:
=IF(ISNUMBER(B2),C2-B2,0)
and then the balances down the sheet will show zero on the unused rows (rows
without a numeric value entered into column B).

Hope that helps some.

"Black_op51" wrote:


JLatham (removethis) wrote:
In C3 put
=D2

You can now fill down the sheet from C3 and from D2 and the formulas will
automatically update and show the values as you make entries into the cells
in column B.

ok, i get that but how do i make it so when i "arrow down" row, excel automatically inputs the previous "D" column in the next "C"column?

Say I click on "C10". The previous "D9" which is 0 will be inputed into
"C10". How do i get excel to do that for me?

Hard to tell - depends on how you're putting the date in it right now. If
you have a formula like
=Now()
or
=Today()
then it will change every time you use the workbook on a different day.
That is, it will update according to the system clock. Probably the quickest
way to stick an unchanging date in a cell is to use [Ctrl]+[;]


"Black_op51" wrote:


JLatham (removethis) wrote:
In C3 put
=D2

You can now fill down the sheet from C3 and from D2 and the formulas will
automatically update and show the values as you make entries into the cells
in column B.


Alright i get it. what about the date? so when i click on "A10" it will
store the the current date automatically and wont change when i open it
again

JLatham (removethis) wrote:
Hard to tell - depends on how you're putting the date in it right now. If
you have a formula like
=Now()
or
=Today()
then it will change every time you use the workbook on a different day.
That is, it will update according to the system clock. Probably the quickest
way to stick an unchanging date in a cell is to use [Ctrl]+[;]


thanks for your time, you helped a lot