FORMULA TO AUTO UPDATE CASH BOOK

[JERRY89]

Hi All,
May I ask is there any formula to auto update daily cash balance,I want to update my cash book in sheet2 daily balance 1st till end of the month so if there is no any transaction in that day it will auto put the figure as above figure by using reference from sheet1 Columm A is date and columm F is the end day cash balance.

[Rudi]

Must the formula for sheet 2 only collect 1 value from sheet 1 or must it aggregate multiple entries in sheet 1?
If it is to collect only 1 value, you could use a VLOOKUP to collect the value from column F based on the current date, and if no entry for current date, then current date - 1.

Is it possible to provide a sample mock-up of the data so as to see the structure of the data you refer to?

[JERRY89]

Hi Mr Rudi,
Thank alot for your reply. Is it possible for me to give u a draft sample of my current situation in my drop box link as below.

https://www.dropbox.com/s/q49hb41wjowex ... .xlsx?dl=0" onclick="window.open(this.href);return false;

[HansV]

If you enter a date for the opening balance in Sheet1!A2, you can use

=VLOOKUP(A3,Sheet1!$A$2:$E$200,5)

in Sheet2!B3, adjust the range !$A$2:$E$200 as needed, then fill down.

Daily Cash Balance.xlsx

[JERRY89]

Hi Mr Hans,

Thanks alot for the reply.It really great ,my problem had been solved .