Need help to write a macro

[kramesh]

Hi all,
I have the following data in sheet1.

id state date
123 A 11/2/05
234 B 11/2/05
123 B 11/4/05
234 C 11/4/05

I need to read the above data and count how many are in State-A , State-B, State-C for a particular date and write the following in sheet2.

Sate-A Sate-B State-C
------------------------------------------------------
11/2/05 <total count> <total-count>
--------------------------------------------------------
11/3/05
-------------------------------------------------------
11/4/05
-----------------------------------------------------
I am new to VB and don't know how to do this. Your help is appreciated.

 

[Norie]

Are you sure you need code for this?

It looks to me like something that could be done with either a pivot table or formulas.

 

[kramesh]

How can I do with the formula? The problem is once the state changes(e: from State-A to State-B on date 11/4/05), the count value for that date in column(State-B) will be incremenated by 1 and count value of Column(State-A) will be decremented by 1