count values in a column and populate table

Hello there VBA experts,

I have a list of faults and each fault has a specific fault code e.g. Hardware failure = fault code 101

There are only a set amount of fault codes in the data I extracted roughly around 10 different codes all listed in Column A with there corresponding data. What I would like to achieve is to populate a table on worksheet 2 listing the number of faults per fault code through a button e.g.

Worksheet 1

A1

101 ....
101
101
102
101
103
104

Worksheet 2

Fault code N.o. of Occurences
101 4
102 1
103 1
104 1

Total N.o of Faults 7

That is my first mission, my second mission is I would like to use this data to create a graph based on monthly statistics of the number faults. As the number of faults in table is going to be used to create the graph when the above macro is updated these numbers are going to change. What im trying to get my head around is how am i going to specify the macro above to publish the next months data in the next column thus creating a new bar in my graph e.g.

Fault code JAN - N.o. of Occurences FEB - N.o of Occurences
101 4 8
102 1 2
103 1 1
104 1 0



Any tips or starting points with this VBA macro would be most welcomed !

Thanks

HB

Thanks alan ! that works perfectly , How would i incorporate this into a macro so i can run it through a button.