+ Reply to Thread
Results 1 to 2 of 2

Drop down menu to reference different sheets in searchable drop down list

  1. #1
    Registered User
    Join Date
    04-01-2019
    Location
    appleton
    MS-Off Ver
    365
    Posts
    1

    Drop down menu to reference different sheets in searchable drop down list

    So I have a searchable drop down list I have created to reference a huge data list on another sheet, I have started sorting this data into other sheets based on "Technology" HID, CFL, FLUORESCENT T5 as a few samples. Does any one have any suggestions on how to make the first drop down in A1 be a reference to the drop down in B2 to pull the data from the specified table with that technology?

    thanks for any help and please let me know if I can clarify anything.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,425

    Re: Drop down menu to reference different sheets in searchable drop down list

    Hello MJAHNKE and Welcome to Excel Forum.
    From the description you want dependent drop downs that reference tables which is a topic covered beginning at 13:21 of the video linked below. That each table is on a separate sheet may complicate the matter, hence the following suggestion.
    Please upload a small desensitized sample of the workbook so that we can test formulas/code using your setup. To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    https://www.youtube.com/watch?v=ws63XhhQi1o
    Let us know if you have any questions.
    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. Searchable Drop Down List
    By mhkeim in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-06-2018, 06:48 PM
  2. [SOLVED] Searchable drop down list
    By roadwreck in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2018, 04:52 AM
  3. Searchable drop down list
    By sradjend in forum Excel General
    Replies: 17
    Last Post: 02-12-2018, 07:38 AM
  4. Searchable Drop down list
    By Jesscyca in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2014, 11:03 AM
  5. Drop Down Menu list for multiple sheets
    By iamreese in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-02-2012, 11:10 AM
  6. Searchable drop down menu?
    By Christoffer_Col in forum Excel General
    Replies: 1
    Last Post: 03-05-2009, 05:04 AM
  7. How to reference list using a drop down menu, displaying the list
    By eddiespaghetti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2006, 04:10 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