+ Reply to Thread
Results 1 to 3 of 3

Auto Populating Date based on dropdown selection

  1. #1
    Registered User
    Join Date
    05-22-2020
    Location
    Ireland
    MS-Off Ver
    2019
    Posts
    2

    Auto Populating Date based on dropdown selection

    Hi all,

    New to this forum so firstly its nice to be here!

    Hoping someone can point me in the right direction with this. I'm creating a timesheet for our staff which would be filled in weekly.

    I am aiming to make it as simple as possible for them, idea being they just need to do a couple of clicks and everything will auto populate for them and they just need to add in times.

    I've gotten so far, example attached.

    What I would love to be able to do, is have the days of the week auto populate correctly.

    Right now, if the user chooses a month from Cell H2, the dates for the first week will populate in the range D7:J7, which is fine in itself but leave me with 2 problems (or challenges )

    Firstly I have the days of the week in the range D6:J6 and the dates don't match up correctly.

    Secondly, this is only populating for week 1. I have a week dropdown in H3 and I would like for the user to be able to pick a week from this and the dates will populate based on this.

    Challenge I have is I am completely stumped as to how to do that!

    Do I need to define what these are somewhere or can this be done using a formula.

    See attached. Only columns A to K will be visible in the final version, the read will be locked and hidden. Any help would be great.

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    528

    Re: Auto Populating Date based on dropdown selection

    Hi there,
    I have added a couple of very short macros into the worksheet for you.
    You don't really need H2 & H3 anymore. Just enter a date into J2. This is formatted to show just the month and year. The first of the month is rarely a Monday (nor will it end on a Sunday).
    The roster will start with the first Monday date set in J2. from there you can simply go one week for or backwards, basically an endless calendar.
    I also updated some of the formulas below...
    See if that works for you.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-22-2020
    Location
    Ireland
    MS-Off Ver
    2019
    Posts
    2

    Re: Auto Populating Date based on dropdown selection

    Quote Originally Posted by ORoos View Post
    Hi there,
    I have added a couple of very short macros into the worksheet for you.
    You don't really need H2 & H3 anymore. Just enter a date into J2. This is formatted to show just the month and year. The first of the month is rarely a Monday (nor will it end on a Sunday).
    The roster will start with the first Monday date set in J2. from there you can simply go one week for or backwards, basically an endless calendar.
    I also updated some of the formulas below...
    See if that works for you.
    Fantastic! That actually is exactly what I was looking for out of this!

    Very much appreciated, thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto-populating a separate sheet based on a dropdown menu
    By Graceful97 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-04-2016, 01:52 AM
  2. Replies: 7
    Last Post: 12-13-2015, 01:01 PM
  3. [SOLVED] Auto populate adjacent cells based on specific dropdown selection
    By ahtigers10 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-02-2014, 08:11 PM
  4. auto populating based on a drop down selection
    By a_sherriff in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2013, 04:43 PM
  5. [SOLVED] Populating information based on selection from dropdown list
    By kearbear in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-10-2013, 11:16 PM
  6. [SOLVED] Auto populate dates of a month based on dropdown selection
    By tstruntz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-20-2012, 10:10 AM
  7. Auto-populate fields based on selection from dropdown?
    By Aswert in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-20-2009, 03:26 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