Prev: creating a pivot with external data source (from access)
Next: Blinking Text
From: Hobbes on 22 May 2010 07:41
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
From: Don Guillett on 22 May 2010 08:15
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
dguillett(a)gmail.com
"Hobbes" <Hobbes(a)discussions.microsoft.com> wrote in message
news:3D868444-51B2-4C37-9EE8-D1D686C91492(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: creating a pivot with external data source (from access)
Next: Blinking Text