Hi Everyone . . .
Not really an Excel VBA expert, so I thought I would come try my luck here. Essentially, what I am trying to accomplish is this:
I have two columns of data that I would like to generate, a date range and an hour range. I have the following range of data in Sheet 1 Column B:
<tbody>
</tbody>
What I need to do is extract the unique values, and then paste them in Sheet 2 Column B 24 times each. In Column A of Sheet 2, I would like to Paste 0-23 (a set of 0-23 for every unique date). This is the desired output:
<tbody>
</tbody>
Any thoughts on how I can make this happen?
Thanks for the help in advance!
Travis
Not really an Excel VBA expert, so I thought I would come try my luck here. Essentially, what I am trying to accomplish is this:
I have two columns of data that I would like to generate, a date range and an hour range. I have the following range of data in Sheet 1 Column B:
Date |
11/11/2013 |
11/11/2013 |
11/13/2013 |
11/12/2013 |
11/14/2013 |
11/14/2013 |
11/12/2013 |
11/15/2013 |
11/11/2013 |
<tbody>
</tbody>
What I need to do is extract the unique values, and then paste them in Sheet 2 Column B 24 times each. In Column A of Sheet 2, I would like to Paste 0-23 (a set of 0-23 for every unique date). This is the desired output:
Hour | Date |
0 | 11/11/2013 |
1 | 11/11/2013 |
2 | 11/11/2013 |
3 | 11/11/2013 |
4 | 11/11/2013 |
5 | 11/11/2013 |
6 | 11/11/2013 |
7 | 11/11/2013 |
8 | 11/11/2013 |
9 | 11/11/2013 |
10 | 11/11/2013 |
11 | 11/11/2013 |
12 | 11/11/2013 |
13 | 11/11/2013 |
14 | 11/11/2013 |
15 | 11/11/2013 |
16 | 11/11/2013 |
17 | 11/11/2013 |
18 | 11/11/2013 |
19 | 11/11/2013 |
20 | 11/11/2013 |
21 | 11/11/2013 |
22 | 11/11/2013 |
23 | 11/11/2013 |
0 | 11/12/2013 |
1 | 11/12/2013 |
... | ... |
<tbody>
</tbody>
Any thoughts on how I can make this happen?
Thanks for the help in advance!
Travis