Expanding between two dates (start and end) along with other information
Hi,
I'm wondering how I can turn this
Customer ID |
Start Date |
End Date |
Type |
Event |
1122334455 |
15-May-18 |
30-May-18 |
A |
Wedding |
1122334456 |
16-Jun-18 |
17-Jun-18 |
A |
Birthday |
1122334457 |
1-Dec-18 |
5-Dec-18 |
B |
Birthday |
1122334458 |
3-Dec-18 |
5-Dec-18 |
B |
Wedding |
|
|
|
|
|
to this
Date |
Customer ID |
Type |
Event |
15-May-18 |
1122334455 |
A |
Wedding |
16-May-18 |
1122334455 |
A |
Wedding |
17-May-18 |
1122334455 |
A |
Wedding |
18-May-18 |
1122334455 |
A |
Wedding |
19-May-18 |
1122334455 |
A |
Wedding |
20-May-18 |
1122334455 |
A |
Wedding |
21-May-18 |
1122334455 |
A |
Wedding |
22-May-18 |
1122334455 |
A |
Wedding |
23-May-18 |
1122334455 |
A |
Wedding |
24-May-18 |
1122334455 |
A |
Wedding |
25-May-18 |
1122334455 |
A |
Wedding |
26-May-18 |
1122334455 |
A |
Wedding |
27-May-18 |
1122334455 |
A |
Wedding |
28-May-18 |
1122334455 |
A |
Wedding |
29-May-18 |
1122334455 |
A |
Wedding |
30-May-18 |
1122334455 |
A |
Wedding |
16-Jun-18 |
1122334456 |
A |
Birthday |
17-Jun-18 |
1122334456 |
A |
Birthday |
1-Dec-18 |
1122334457 |
B |
Birthday |
2-Dec-18 |
1122334457 |
B |
Birthday |
3-Dec-18 |
1122334457 |
B |
Birthday |
4-Dec-18 |
1122334457 |
B |
Birthday |
5-Dec-18 |
1122334457 |
B |
Birthday |
3-Dec-18 |
1122334458 |
B |
Wedding |
4-Dec-18 |
1122334458 |
B |
Wedding |
5-Dec-18 |
1122334458 |
B |
Wedding |
I have to do this for more date ranges so I'm hoping to find a better way of doing it. I'm a VBA newbie as well.
Thanks for the help!