Moving sum from one cell to another cell

  • Thread starter Thread starter Jim Pennington
  • Start date Start date
J

Jim Pennington

Hello,

Brand new to this forum and fairly new to Excel. I have created a for
for keeping up with loan activity our farm makes to it's employees.
Attached find a copy of the form. What I am wondering is whether it i
possible to take the "loan balance" (which is the red cell on th
right) and transfer that value to the "previous balance" cell (th
other red cell to the left and staggered down one row) and have thi
operation repeatable each time a loan entry is made. I only want th
loan balance number duplicated only once for each seperate entry in th
previous balance cell in the next row. I tired the "link cells" optio
but that wasn't doing what I wanted. Thanks.

Jim
http://www.geocities.com/penningtonj.ge
 
Hi
enter the following in your cell C7:
=G6
and copy down
or if you want to test if the row above is filled use the following in
C7
=IF(B6<>"",G6,"")
copy this down and voila

HTH
Frank
 
Back
Top