+ Reply to Thread
Results 1 to 3 of 3

Drop Down choices should reflect choices

  1. #1
    Registered User
    Join Date
    07-29-2020
    Location
    USA
    MS-Off Ver
    Newest
    Posts
    12

    Drop Down choices should reflect choices

    Hello,

    So I have 4 sheets involved.

    The first sheet (Testing Info) has three drop-downs...but this will actually be two. So I'm only concerned with the first and last one. They are not dependent.

    On that first sheet (Testing Info) where the drop downs are, when a choice is made, it's supposed to cause ids to change in the second sheet (Results). (ID's WILL be part of the second sheet (Results) and will be hidden fields). A user is at this stage supposed to enter student info in to to this sheet. ID's are not there yet in that Result sheet but they are meant to replace almost all those other hidden fields. There are many hidden fields now.

    The 3rd and 4th sheet (Location and Tests) have the data that is associated with the ID's. (meaning, the data is not simply to the right of the ID's in the same sheet)

    I hope someone can help with this. Very little experience with Excel.
    Last edited by ed1984; 08-03-2020 at 07:23 PM.

  2. #2
    Registered User
    Join Date
    07-29-2020
    Location
    USA
    MS-Off Ver
    Newest
    Posts
    12

    Re: Drop Down choices should reflect choices

    I have attached a sample.

    You will notice that when you change the drop down in the first sheet ('Test Info'..in the 'Results' tab..(if you unhide the columns in Results tab)...
    they change depending on drop-down.
    Attached Files Attached Files
    Last edited by ed1984; 08-03-2020 at 07:17 PM.

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,738

    Re: Drop Down choices should reflect choices

    If I correctly understand the intent then I believe that a table connecting the ID's to the Fire Department and Standard is needed (as modeled on Sheet1).
    The formula to find the ID's on the Results sheet could be:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Dependent Drop Down list to autofill next drop down with selective choices
    By MitchellHydro1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-08-2015, 01:18 PM
  2. Drop-down list choices restricting choices of other lists?
    By not_quite_excelling in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2011, 06:04 AM
  3. Replies: 8
    Last Post: 02-22-2008, 12:53 PM
  4. Drop Down List -- More Choices?
    By cybercab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2007, 12:40 PM
  5. Drop Down with multiple choices?
    By TPD in forum Excel General
    Replies: 7
    Last Post: 02-07-2007, 02:36 PM
  6. Drop Down Choices in a cell
    By Mary A in forum Excel General
    Replies: 1
    Last Post: 07-25-2006, 05:40 PM
  7. How do I add drop down choices to a spreadsheet?
    By Wendy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-20-2006, 07:00 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