Hiya folks
Quite a simple problem I suppose but causing me a real headache
I have a single worksheet
Col a - Date
Col b - Money In
Col c - Debit Card
Col d - Cash
Col e - Balance
From the above you can probably see that in Col B i enter the money paid into the account...then using Col's B & C...Col E displays the remaining balance in the account!
Col e = sum(B5-C5-D5)
simple I know but all I need I suppose
However I want to display the current date and the balance somwhere on the same worksheet...say for instance the top left cells B2 & B3
B2 = Date in dd/mmm format
B3 = The value found in cell E on the corresponding date
can anyone help with this as drove me in circles for the last day or 2????
thanks folks
zym
Bookmarks