Manipulate dataset in a quarterly format

Dear All,

I am new VBA user and I would like your help because I am getting crazy. I am using a data set with 2 columns. In the first one I have the years (1970-2013) and in the second column the month of an event. What I am trying to do is to manipulate these two columns and create a third one collecting the number of these events in a quarterly form. For the quarters that no event has been occurred I just put a 0 for them.

The problem is that my code is working fine until it meets a missing year. There is something wrong and I CANT SEE IT. Can anyone help me with it please?? I have attached my data set. Much appreciated.

Please Login or Register  to view this content.

While I take a look at it can you amend your title? as per....

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

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

(note: this change is not optional )

Im not certain you need all those ElseIF statements but in the interests of a quick answer I think that if you change the following:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

It should do it