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!
Bookmarks