Hi friends,
I want to create a balancesheet of my accounts. I want to transfer the latest entry of each of my account from sheet 'Account' to sheet 'Summary' automatically after entering the data in the account.
The final output of it should be as follows in 'Summary' sheet:
ACCOUNTS
NAME OF BANK DATE PARTICULARS WITHDRAWN DEPOSIT BALANCE
Bank of A 10-01-2014 By cheque 0 300 700
Bank of B 15-01-2014 By cash 0 5000 6200
Bank of C 20-01-2014 By cheque 0 3000 3700
Bank of D 28-01-2014 By cheque 0 6000 8700
Bank of E 14-01-2014 By cheque 0 5000 5700
Bank of F 18-01-2014 Self 500 0 200
Please suggest me a code to achieve this target automatically.
Thanking you in anticipation.
Regards,
Mukesh
Bookmarks