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!