autofilter master copy data to worksheet
 

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

autofilter master copy data to worksheet
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Hobbes" wrote in message
...
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