Hi Waqer
I have created a Pivot Table Report using the Scheme Number as the key on a new Sheet called Account Summary. Click on the drop down field in B2 on this sheet to view all transactions for a selected Scheme.
Hope this is what you are looking for.
Good luck.


Tony(OTPM)

Attached Files

Ledger.xls (44.5 KB, 13 views)

This is not what I am looking for. I think I can view transaction by simply applying filter. I want to automatically fetch all transactions of particular scheme with all details such as invoice amount, date, taxes etc in relevant columns upon selecting account #. I must use given format (on ContractLedger sheet) for calculation of remaining balance.