Auto-Paste Data on save to Another Sheet

Hello sir,

I m new in excel VBA & Coding..

I have a sheet as attached..i want if i select an account Head under clomun D and then authomatically all data from column C to G should go to another sheet already exists with the same name in cell D3.(which i selected). and hense i want to add down every row contineously so that i can get accout separtely..

Is it possible and can u do it for me please.

Thanks

Ledger.xls

Thanks for reply and give your kind look at my problem..

Actually i to maintain it sapertaly so that any time i can get print of each account and it will be look like a software which i like to have..i will just enter in main sheet and automatically my all accounts will be updtated..thats what i want..and secondaly i dont know also pivit table..

Thanks..

Thanks for kind suggestion...

I will read it also..but i will be highly appreciate if you make my attached sheet in pivit table for me so that i can follow it..cuz i need it also urgently to maintain my accout..i neet each transaction and each column separtely..

So, kindly work on my attached sheet and send it to me..thanks
Thanks..

hello sir,

can you do my requirement by using pivit table so that i could know how to use pivit talbe

Thanks..

Mr. Roy UK,

I m still waiting for your help..

Pls send me VB Code of my requirements..

Thanks