+ Reply to Thread
Results 1 to 2 of 2

How to change values based on selection in drop down menu

  1. #1
    Registered User
    Join Date
    05-27-2016
    Location
    Baltimore, Maryland
    MS-Off Ver
    2017
    Posts
    6

    How to change values based on selection in drop down menu

    Hello Everyone,

    I am trying to make an attendance tracker. I have the calendar up and running.

    I have a drop down list for employees. The issue that I am having is that the calendar won't change based on the employee. I want to be able to select the employee name from the drop down list an have the values changes such as present,absence, etc in the calendar. Any help is appreciated. Thank you everyone!Copy of fiscal-year-calendar.xlsx

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: How to change values based on selection in drop down menu

    Hi Minky, after looking at your sheet, it is not obvious what you expect to change when different names are selected, nor what those changes would be based on.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. How to change values based on selection in drop down menu
    By minky2488 in forum Excel General
    Replies: 11
    Last Post: 05-28-2016, 04:25 PM
  2. Locking a formula in a column where the values change based on drop down menu
    By uhm_81 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2014, 09:57 PM
  3. Formula based on drop down menu selection
    By danjpalmer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-21-2014, 03:45 PM
  4. Replies: 1
    Last Post: 03-27-2013, 07:04 AM
  5. Replies: 3
    Last Post: 01-31-2013, 06:22 PM
  6. Changing values based on drop down menu selection
    By henro8 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2010, 03:47 AM
  7. change cell values based on drop down box selection
    By Aniruddha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2006, 05:30 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