alexaferrer
07-30-2018, 10:16 PM
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!
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!