Hi everyone, I have actually a userform where users enters the dates of leaves and most of the time it goes beyond one day. I have various kind of leaves as well (vaccination leave, worked holiday, annual leave etc).
I have included a scrceenshot of my table back end when user form is being updated.
Screenshot No.1
How can I show the dates one column instead . That means you can see in the screenshot above that in rows 2 and below, the dates are shown in column g and h. I want the dates applied to show only in column g and the rest of data to repeat itself till the end date (the employee name, ID,leave type etc should show in a repeated manner. I have attached another screenshot (screenshot no.2) on how I would like the desired data to look like using the same data in the screenshot no.1.
Screenshot No.2 ( DID it for employee EE)
Can any expert help me on the vba codes as soon as userform is clicked and the table is updated like screeenshot no.2 instead of no.1. This will relieve a big headache for me.
I have shared the file via google also.
Individual Leave Report test.xlsm
Thanks for your generous help!
I have included a scrceenshot of my table back end when user form is being updated.
Screenshot No.1
How can I show the dates one column instead . That means you can see in the screenshot above that in rows 2 and below, the dates are shown in column g and h. I want the dates applied to show only in column g and the rest of data to repeat itself till the end date (the employee name, ID,leave type etc should show in a repeated manner. I have attached another screenshot (screenshot no.2) on how I would like the desired data to look like using the same data in the screenshot no.1.
Screenshot No.2 ( DID it for employee EE)
Can any expert help me on the vba codes as soon as userform is clicked and the table is updated like screeenshot no.2 instead of no.1. This will relieve a big headache for me.
I have shared the file via google also.
Individual Leave Report test.xlsm
Thanks for your generous help!