Excel 2003 Macros and Variables

[Randy Brown]

I have a request, which lead me back to something I've always wondered. I
have a worksheet with columns of data

Date numbers name
..
..
..

I get the data as something that is raw, and I need to sumarize it by date.
Is there a way to write a macro that would go all the down the columns and
summarize? Sort of:

if Date = "21-Oct-2009" then a = a + 1

I would then copy that macro to another cell and update that macro to
"22-Oct" and it would summarize for that date, and so on...

Possible?

 

[muddan madhu]

U can use formula to get results

=IF(A1=DATE(2009,10,21),COUNTIF(A$1:A1,DATE(2009,10,21)),"")

 

[B Lynn B]

Seems like a pivot table is more what you're looking for, rather than VBA code.