Formulas in my Workbook

[hrbsh97]

I have a workbook with multiple worksheets .. I have columns for date,
vendor, payment, balance .. and it is set up to subtract the payment from the
balance each time I make an entry. I just had to add about 20 rows .. am I
going to have to manually go in and enter a formula telling Excel to subtract
each time or is there an easier way?? .. hope this makes sense .. thanks much
to all the experts out there for your help!!

 

[Spiky]

I have a workbook with multiple worksheets .. I have columns for date,
vendor, payment, balance .. and it is set up to subtract the payment from the
balance each time I make an entry. I just had to add about 20 rows .. am I
going to have to manually go in and enter a formula telling Excel to subtract
each time or is there an easier way?? .. hope this makes sense .. thanks much
to all the experts out there for your help!!

You should be able to copy the formula from existing rows to all your
new rows.