Creating Account Transactions Summary

Hi all,

I am studying a lengthy account and it is difficult to visualize a loss/increment in the a batch of mixed transcations.

Below is the simplified account history:

Attachment 501532

and I hope some vba can:
- group and the arrange the transcation date in chronological order, indicate the net change
- produce a summary of the groups

Basically I think some code can:
1. filter the transcation records with keyword: 'BOUGHT', 'SOLD' and check the appending wording to creat a list of keyword (e.g. 'XXX', 'YYY')
2. use the first keyword (e.g. 'XXX') to sort the transcations with those keywords and print the summary group
3. calculate the NET change for that group
4. loop to the next keyword until the last keyword
5. calculate the NET change for all groups

Attachment 501535

I am not familiar with programming code, would a vba expert please spare 5-10 minutes of your time to help~~!

YOUR TIME AND HELP IS MUCH APPRECIATED. THANK YOU!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.