Formula??? Help!!

[travwil]

Hey guys,
I'm tryin to create a worksheet that subtracts a value from another value and displays the result in a box. Well i have it down, but it looks like i'm going to have to enter it 125 times for each line!! Is there any way to shortcut this???

The worksheet is for a day care to display the running balance for a customer. so in colum A=date B=Description C=Amount Charged D=Amount paid E=Balance

So my formula for say Cell E7 would be =D7-C7, Cell E8 would be E7+D8-C8, Cell E9 would be E8+D9-C9, E10 would be E9+D10-C10, and so on..... Well i need 125 lines, because they only use one sheet per customer per year. and it looks like i have to type this formula in 125 times... MY QUESTION is: is there a way to fill the rest of the E cells in automatically?? Can Excel see the pattern of the formula and repeat it?? Please help i need to get this done. and if i have to type it in 125 times i need to get started... If anyone needs a copy of the worksheet that i have started, let me know.. thanks!!!!

[ph8]

Edit > Fill > Down/Right

That should do it for you. Excel is pretty smart about continuing patterns. If you need to reference an absolute column, row, or cell, use the $ sign.

For instance, if Column C, at row 1 had:
=A1+B1

Filling down would result in the following formulas: (italic is the row number)
2: =A2+B2
3: =A3+B3
4: =A4+B4

But if the formula in row 1 was this:
=A$1+B1

The fill down command would result in the following:
2: =A1+B2
3: =A1+B3
4: =A1+B4

That is an example of referencing an absolute row, an absolute column would of looked like this:
$A1
And an absolute cell (where the cell target won't change regardless off fill direction)
$A$1
------

I hope this is what you were looking for.