Excel Assigning Value In Table Problem ( Shifting Problem )

Greetings From Turkey

This is my first topic , i hope you can help me.

I have a little excel file for my expenses. I attached my file to this topic you can download from here.

I want your help at this point.
My table has expenses in rows and i have 3 types of source. credit card 1, credit card 2 and cash in my pocket. my F5 value is my initial cash money, if i spend cash, i assign final value to G5. First row of my table is $30 expense and i paid as cash so my final money is 70.

I want my table to assign G5 to F6, G6 to F7 etc. When i add new row, i want previous rows final value automaticly assign to new rows initial value in my table

Thanks!

Hi, welcome to the forum

Try this...
=IF($E6="","",G5)

Use Excel Table not a Range "table"

Ooops my excel was minimized so I didn't notice it is Excel table

anyway you can add new row with TAB key so it will copy your formulas properly down

here is

now put pointer to the last row (in this case B8) and hit TAB few times to create new row (it should go thru the whole row to the end and jump to the new row)
then enter new data
I changed Ford's formula to =IF(ISTEXT(G4),100,IF($E5="","",G4)) because I don't know how you get 100 in F5
you can modify this for your requirements