Userform Start and End Date Populating Results Sheet

Hello! I've been reading your forum for a very long time, and have learned a lot from it, so thank you. Now, I have a project I need help with that I've not been able to find anything on the forum or internet in general about it. (Which makes me wonder if what I'm looking for is even possible...) Here it is (forgive me for the length of my post):

(I am working with Excel 2010 and 2016 if that matters). I have a .xlsm workbook that I intend to use for my team to request PTO (vacation days). The userform currently has the following fields that are filled in by the user to request PTO:

1. Name (combo list)
2. Request Type (combo list)
3. Start Date (text field)
4. End Date (text field)
5. Available PTO hours (text field)
6. Additional notes (text field)

Once the user is finished entering all the information, they hit the "save" button. The save button does a couple of different actions:

1. Sends me an email, so I know a new request has been entered, (so I know to go in and approve or deny it).
2. Populates the corresponding fields on my "results" sheet.
3. Then, it clears the userform and closes it, leaving the workbook itself open.

Action #2 is what I am trying to enhance. Is there a way to code the userform to enter all of the dates being requested on my results form so that I am seeing each individual day on its own separate row? For example, if someone is requesting a start date of "1/2/2019" and an end date of "1/4/2019" - can I get it to populate on three separate rows instead of just one? So I would see three requests from this employee for 1/2, 1/3, and 1/4.

Please let me know if this makes sense - I can post a copy of what I have if you need to see it! And thank you in advance for any assistance you can give me!

Hi and welcome

I'm sure this is possible and not too difficult.
Would be a lot easier to help if we could see the file though.

BSB

Sorry, I'm trying to figure out how to attach the file... I'm not seeing an "add attachment" button

Here is my file...

Originally Posted by Richard Buttrey

When the 3 rows are added are all of columns B:I exactly the same? i.e. no change to the userform is needed?

If you upload the workbook it should be a simple thing to change.

Hi Richard - as far as the columns being the same - yes, that's what I'm thinking, but if they can't be, I could work with that also.

Thank you, Richard ... I got a couple of compile errors for "variable not defined" - I figured that out (some of the code was showing "lrow" and some was "lrows") so I updated those to "lrow" instead, then I was able to get through the process of entering my information in the form and hitting save. But, the first request I made populated 30 rows of identical data (I was only requesting 4 days of PTO)... then the second request I made (for 2 days of PTO), returned 60 rows of identical data.

I was hoping to have only the number of days being requested match the number of rows being populated. Is there another tweak you can think of to do that? But, we're definitely on the right path!!

Perfect!!! That's exactly what I was looking for - thank you so much Richard, I really appreciate your help!!