Code to transfer latest entry from sheet 'Account' to sheet 'Summary' automatically

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

I wrote the macro that will postn all bank accounts into summary and mark each entry as posted

Note: it is unclear what to do with the balance column in the summary (I copied the balance from the bank account)

Hi Bsalv,
Excellent! It's working fine.

in the code 'dim (1 to 100, 1 to 6)'

What does the number 100 and 6 means/refer?

Thank you RCM and Bsalv for solving my problem.

Have a nice day!

Regards,

Mukesh


[code]

Hello Bsalv,
Thank you for explanation. Now I understood the code. I will modify it for deposit and debit sheet also. If I have any problem I will take your guidance positively.

Thank you.

Regards,

Mukesh

Hello Bsalv,
Please see the pdated file and do modify the code to get correct output. I want all the 'FD' entries in the summary sheet and not as other macros 'account' and 'debit' latest entry.

Extremely sorry for trouble and thanks for guidance.

Regards,

Mukesh

Hi Bsalv,
Thank you for revision. But this code is not working. I'm getting message 'excel found unreadable contents .. file name .. if you trust it then click on yes/no'.

This code is hard to understand me. Your first code was very good only I want to correct the 'summary_debit' code to get correct output.

Secondly I want the entire list of my deposits in the summary sheet. So there is need to change the code.

I don't want total at the bottom of the table because I have already created a summary table at the leftmost side from column 'b'.

Please do the revision and tell me where I was wrong. So that I will learn it and avoide it in future.

Sorry for trouble and thank you for your kind assistance to solve my problem.

Mukesh

Yes, I agree with you. I use it and know how to get output on another sheet using formulas. I don't want to use formulas for a large database because it increases the size of file. A single macro does a lot of work which several formulas do and lessen the size of file.

So I want to have a vba code to achieve my target.

I request you to correct 'summary_debit' code and change 'summary_deposit' code to get desire correct output. It will be more helpful for me.

Thanking you in anticipation. Sorry for trouble.

Mukesh

Hello Bsalv,
Excellent! Now this is easy to understand for me. It's working fine with correct output.

Thank you very much.

Regards,

Mukesh