Hello All,

I am new to VBA and have run into a roadblock that I need help with. I normally generate an Excel report that generates a column of dates and attendance status (see below Columns A and B). What I need to accomplish is to write a VBA code that:

1. Loop through column A and find the number of different months and list them in column D. In the below example, it would be 3 different months so cells D2, D3, D4 would have July, August, and October respectively

2. For each month, find the number of records. In the below example, it would be 3 for each month so cells E2, E3, E4 would have 3, 3, and 3 respectively

3. For each month, find the number Early, Late, Absent records and list them in columns F, G, and H respectively.

Thank you for your help in advance.

Travis.

I am new to VBA and have run into a roadblock that I need help with. I normally generate an Excel report that generates a column of dates and attendance status (see below Columns A and B). What I need to accomplish is to write a VBA code that:

1. Loop through column A and find the number of different months and list them in column D. In the below example, it would be 3 different months so cells D2, D3, D4 would have July, August, and October respectively

2. For each month, find the number of records. In the below example, it would be 3 for each month so cells E2, E3, E4 would have 3, 3, and 3 respectively

3. For each month, find the number Early, Late, Absent records and list them in columns F, G, and H respectively.

Thank you for your help in advance.

Travis.