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.
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.