Hello,
I am requesting assistance to an ongoing challengeI am having. I have a
master spreadsheet with a total of 12 Columns. Column 6 is a date column and
column 8 is a two-digit hour column (HH). Column 12 is the AI_Name column
where all the names are the same. I am looking for a macro that will filter
each date and count the number of occurrences that occurs between each hour
of the day for that date in a 24 hour period and paste the results into a
€˜summary type sheet with fixed columns. The summary sheet should be created
in the macro, creating a new worksheet that takes the same name in column 12.
The summary sheet columns are fixed where column A is the date. Column B,
Column C, Column D, through Column Y have fixed column headers where column B
is TIME_0_1, column C is TIME_1_2 all the way through column Y, with the
header TIME_23_24.

If possible, I am looking for a macro that can do this.

I can provide additional clarification and a test workbook with the data as
necessary.

Thank you,
Ken