Home expense spreadsheet

[Chev454ss]

I'm building a spreadsheet to track home expenses and want to keep a running total. In column D I have the expense, in column E I am subtracting the amount from D and placing it in column F. I would ask for a method to transfer the number from column F to column E so I don't have to copy/paste the numbers every time. Is it a move function? I can't make sense of threads I search on google.

 

[kweaver]

Please use XL2Bb to show a sample of your data and the outcome(s) you expect.

 

[Toadstool]

Hi Chev454ss,

Is this what you mean?

Chev454ss.xlsx
	D	E	F
1	Expense	Payment	Running Total
2	100	100	0
3	80	40	40
4	20	20	40
5	45	85	0
6	22	0	22
Sheet1

Cell Formulas
Range	Formula
F2:F6	F2	=SUM(F1,D2-E2)

 

[Chev454ss]

I believe so! I'll try it. Thank you for your reply.

 

[Chev454ss]

This is what I have. I want to transpose/move the number in column F (balance) to column E (sub total) where I have a formula to subtract column D from column E and place it in column F. This will make it so I can input a number in column D and automatically do the math and place the result of the figure in column F into column E.

AMOUNT	SUB TOTAL	BALANCE
	54698.90
4795.4	54698.90	(49903.54)