VBA code

Here's a piece of data that I exported from our IVR machine as a text file and exported it to excel.

I want to want to count the number of hits taht equal M1 or M2 or M3 or M4 taht indicate open or closed and taht are associated to the their corrisponding CDN number 36771 or 36792 or 36794 etc.

Here's the code.

00-963850841-A 0 89001 9529240000 7172000 920 TradeCode
12-963850827-Z 28 M4 open 36772
17-963850821-~ 41~ open
05-963850875-A 0 89001 6104595609 7172000 921 TradeCode
00-963850841-Z 42 M1 0.3 open 36771
22-963850821-Z 71 M1 0.3 open 36771
05-963850875-Z 33 M3 open 36771
08-963850911-A 0 89001 7605971500 7172000 921 TradeCode
23-963850919-A 0 89001 3038385130 7172000 921 TradeCode
16-963850945-A 0 9001 6093944000 7172000 922 TradeCode
23-963850919-Z 37 M2 open 36793
06-963850963-A 0 89001 077613879 7172000 922 TradeCode
18-963850833-Z 134 MTO open 36771
08-963850911-Z 68 M1 8591E 440012558 open 36771
10-963850989-A 0 89001 4104033300 7172000 923 TradeCode
10-963850989-~ 13~ open
11-963851032-A 0 89001 2017677106 7172000 923 TradeCode
09-963851054-A 0 9001 3167831345 7172000 924 TradeCode
01-963851066-A 0 89001 5133851719 7172000 924 TradeCode
04-963851076-A 0 89001 3026338000 7172000 924 TradeCode
11-963851032-Z 50 M2 open 36792
01-963851066-Z 17 M0 open 36771
09-963851054-Z 33 M3 open 36771
16-963850945-~ 143~ M1 M1400-60012 440012558 open
07-963851138-A 0 89001 6103804663 7172000 925 TradeCode
06-963850963-~ 185~ M1 08757-60034 440012558 open
03-963851148-A 0 89001 4808355839 7172000 925 TradeCode
07-963851138-Z 23 M4 open 36772
15-963851212-A 0 89001 9103542125 7172000 926 TradeCode
04-963851076-Z 146 M2 0.3 440012558 open 36771
03-963851148-Z 95 M2 0.3 440012558 open 36771
15-963851212-Z 33 M3 open 36771
19-963851270-A 0 89001 8282625230 7172000 927 TradeCode
02-963851296-A 0 89001 5165963743 7172000 928 TradeCode
19-963851270-Z 34 M3 open 36771
20-963851310-A 0 89001 7708137000 7172000 928 TradeCode
02-963851296-~ 18~ open
20-963851310-Z 20 M3 open 36771
12-963851392-A 0 89001 3034695335 7172000 929 TradeCode
12-963851392-Z 40 M4 open 36772
17-963851442-A 0 89001 8158841417 7172000 930 TradeCode
00-963851464-A 0 89001 3302638100 7172000 931 TradeCode
17-963851442-Z 41 M4 open 36772
22-963851486-A 0 89001 8015300741 7172000 931 TradeCode
00-963851464-Z 37 M2 open 36793
05-963851510-A 0 89001 8158841417 7172000 931 TradeCode
21-963851528-A 0 89001 7066851375 7172000 932 TradeCode
05-963851510-Z 20 M4 open 36772