Results 1 to 12 of 12

Userform Start and End Date Populating Results Sheet

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2018
    Location
    Arizona, USA
    MS-Off Ver
    MS Office 2016
    Posts
    16

    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!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Populating dates below a start date
    By Ksun23 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-22-2018, 12:45 AM
  2. [SOLVED] Populating userform textboxes basis of results from 2 userform comboboxes
    By rlh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-11-2017, 10:26 AM
  3. Populating cells in planning according to start and end date
    By frencholivier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2015, 11:01 AM
  4. Replies: 4
    Last Post: 08-29-2014, 09:57 AM
  5. [SOLVED] Populating A Matrix from results sheet
    By Foreverlearning in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 03-30-2012, 04:41 PM
  6. Populating column with dates based on start and end date
    By mdavid800 in forum Excel General
    Replies: 5
    Last Post: 08-07-2011, 12:49 PM
  7. Populating UserForm TextBoxes from ListBox results
    By AGrace in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2010, 03:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1