coding / counting/ showing?

[vbanewbie2]

ok I have this code that populates every thing as it is supposed to do, my problem is counting....

I have a column (B) that gets populated with the follwing month/year info (I.E. JAN2010, FEB2010, etc).
I need to be able to count how many JAN2010 there are, How many FEB2010 there are, etc...

I have tried using a formula on the spreadsheet it self, but every time it gets populated it gets over written with blank cells.

I have tried a Pivot table But that too gets over written as it gets populated.

So I think I need something in the code that will help show the following on the worksheet (results):

Jan2010 23
Feb2010 46
Mar2010 53

Can any body assist with this.

[Guido Geurs]

You have to create an array with the different types of data (jan2010,...) and there frequencies.
Once checked all date, dump the array in the sheet. (see attachment: run the macro= "Macro_Coun t")

[vbanewbie2]

I tried the array but it did not work.

this is what my output looks like.

I need to find out how many Jan2010's there are in column B, How many Feb2010 there are in column b, etc

Workbook Worksheet cell# Text in Cell
oneshot 2010.xls Jan-10 $F$29 JJV

[vbanewbie2]

Workbook | worksheet |cell | Text in Cell
oneshot 2010.xls | Jan-10 |$F$29 | JJV

[Guido Geurs]

My attachment is an example how it works !
You have to modify it so it works on Your layout.
Is it possible to attach in Bytes an example of Your sheet or a part if it's to big so I can see what must modified in the macro ?
Also an example how You want to be the result?
How: goto "Post replay" or "Go Advanced" and click on "Manage Attachments" !! XLS files must be ZIPPED : see list with allowed types and size !