JonRowland
Active Member
- Joined
- May 9, 2003
- Messages
- 417
- Office Version
- 365
- Platform
- Windows
Hi Forum experts. I am hoping someone can help with some VBA code for me to do the following, as all my attempts have failed
For the purpose of this post I have simplified my example data but will likely have around 6-7 time periods and x amount of CallCodes.
What I start with is a list of Time Periods and CallCode that occurred within the period, as below
What I am trying to do is produce a result like this
Before anyone asks why not use a Pivot Table this is part of a bigger routine and what to include this automated part.
For the purpose of this post I have simplified my example data but will likely have around 6-7 time periods and x amount of CallCodes.
What I start with is a list of Time Periods and CallCode that occurred within the period, as below
Time Period | CallCode |
00:00 - 05:59 | Y24 |
06:00 - 11:59 | X01 |
15:00 - 20:59 | D09 |
15:00 - 20:59 | X01 |
What I am trying to do is produce a result like this
CallCode | 00:00 - 05:59 | 06:00 - 11:59 | 15:00 - 20:59 |
Y24 | 1 | 0 | 0 |
X01 | 0 | 1 | 1 |
D09 | 0 | 0 | 1 |
Before anyone asks why not use a Pivot Table this is part of a bigger routine and what to include this automated part.