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)
|