unsolved

Memo Date Party Code Quantity Price Payment Balance
01-02-12 501 200 1000 500 500
02-02-12 501 100 500 100 400
05-02-12 503 500 2500 200 2300
01-03-12 504 100 500 200 300
02-03-12 504 100 500 300 200
20-02-12 501 100 500 100 400
21-01-12 503 100 500 500 0
I want to group the month wise data as per party code,total quantity,total parice,totalpayment,and total balance
from worksheet name "monthly Total"
data can be obtained from other sheet name "MyData"
I am new in VB so kindly provide easy method to obtained data and get result as required.
thanks

How about a pivot table?

Toqeer,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

no pivot table i want to see the result regularly when i post new entries