+ Reply to Thread
Results 1 to 6 of 6

Checklist in Excel that is dependant on date selected from drop down menu

  1. #1
    Registered User
    Join Date
    03-26-2020
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    5

    Post Checklist in Excel that is dependant on date selected from drop down menu

    Hi there,

    I have attached a copy of a table which I want to make dynamic (I think this is the right word)

    Basically I want a new form (a2:d42) to appear when I choose an option from the drop down list in a1. So instead of having 20 worksheets, one for each checklist, I can use the menu to move between the checklists on the one worksheet.

    Any help would be greatly appreciated

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,849

    Re: Checklist in Excel that is dependant on date selected from drop down menu

    You sample file does nothing to explain your question.
    I'm sure you understand your question but think of a third-party that has no idea and needs to picture it.
    Do you want a user form with dropdown lists? Comboboxes? What is the result you want.
    Maybe add it manually and see if we can figure it out
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    03-26-2020
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    5

    Post Re: Checklist in Excel that is dependant on date selected from drop down menu

    Good Morning,

    Thank you for reading my question,I will try and be more articulate because reading back over my question it was definitely not very descriptive!!! I am also not very good with excel so my lingo is
    terrible.

    I have attached a copy of a calendar which is similar to what I am looking for.

    If you look at the January worksheet - the arrow that moves through the year is similar to what I am looking for, where the the table updates the dates/days relevant to that year. In my case,
    I want any data that I record manually in cells B3 to D42 to be dependent on what has been selected from the drop down menu in A1.

    In this example, however, when I put the letter d in C7 of this worksheet, it continues to show up even when you change the year. I would like the data in my table to be special to the
    option which has been selected from the drop down menu (A1 in my example)

    So for the new example I have attached - if it was working the way I need it to, I could put the letter d in C7 in 2016, and it would only appear in C7 if 2016 was selected.

    Example:

    A1 "02/04/2020 The Other side cafe" is selected from the drop down menu

    Data in B3 is text - 16PAX 12pm


    BUT

    If I change A1 to 03/04/2020 Friendship Friday - I would like the checklist table (A2:D42) to show only data that I enter for that particular date.

    So instead of creating a new worksheet for each checklist (i.e one worksheet for 02/04/2020, one for 03/04/2020 etc.) I was hoping that the drop down menu A1 could do the work for me.
    Attached Files Attached Files

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,849

    Re: Checklist in Excel that is dependant on date selected from drop down menu

    Let me try to put it down in English.
    You have a 12 worksheets for every month of a year and the year you change by clicking the arrow in the sample calendar file you copied from the internet, correct?
    In you fist sample you have a series of dates, probably holidays or similar with a data value and the text describing that date.
    I am assuming that what you want to display that text in the corresponding month and day of the corresponding year?

    It's past midnight here so I'm off to bed.
    I think you should put together one month with what you have and what you want to see.
    I'll see if I can help tomorrow.

    Good night.
    VBA is not that complicated, it's just logic adn it does exactly what you tell it to do, true, you need to know the syntax, but the limit of what it can do is the imagination of the programmer

  5. #5
    Registered User
    Join Date
    03-26-2020
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    5

    Re: Checklist in Excel that is dependant on date selected from drop down menu

    Hi there,

    I don't think I have explained myself well at all, I am so sorry.

    I hope I haven't given you a headache, thank you so much for looking at it for me.

    If I get a chance I will research what I am after today and if I find a solution I will post up what it looks like.

    Have a great night

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,849

    Re: Checklist in Excel that is dependant on date selected from drop down menu

    Good morning, no headache , let me know when you got it sorted out.
    If its special dates I suggest you modify you list of dates and place it in two columns, one for the date and one for the text
    You can make the dates dynamic by using the year value in the calendar sheet.
    Only if there are special days like always a friday or the nth tuesday in a week/month then you'll need extra code.

+ 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. Data Validation That Feeds A Dependant Drop Down Menu
    By Cammy1984 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-18-2015, 03:25 AM
  2. Replies: 0
    Last Post: 02-18-2015, 10:27 AM
  3. Need help with creating a dependant drop down menu that performs calculations
    By excerbated123 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-04-2015, 02:33 PM
  4. Replies: 2
    Last Post: 01-29-2015, 12:31 PM
  5. Excel drop down menu that draws information dependant on value
    By morgan8311 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2014, 02:58 PM
  6. Make Drop Down Menu Default to One Value dependant on another cell
    By zhunter71 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2013, 02:56 AM
  7. How to change selected drop down choice automatically when a dependant field changes.
    By pepimartinez in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-04-2011, 07:22 PM

Tags for this Thread

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