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!