dependent dropdown lists

Hi Everyone, I have been trying to get this to work for a few days straight and i'm stumped. I'm trying to create a dropdown list inside a table that searches another table nearby fo all the sets that fall if the date logged is between the start and end date for that set. I have attached an...

Hello, I have been scouring the internet and these forums to see if I can find a truly dynamic scheme for dropdowns. I have seen lots of solutions that depend on many named ranges, but I am hoping for more of a tabular approach. Here is the situation: I have a single table that has a group...

Hi there, I am making some drop down lists but the options that one returns is dependent on what has been entered into two other drop downs. I know you can link then up by using the INDIRECT function if there is only one other list that affects it but how would I do it if there are two. For...

Greetings everyone, Upon coming across this very helpful forum, I came across a post that up-until now has been extremely helpful. The link to the thread can be found here. The project that I have been given at work was to create a user form that has dependent combo boxes that will be used to...

Hey there, I'm trying to make a dependent list auto populate based on the first selection. I understand how to make dependent lists. How do i make the list in column a, auto populate columns b & c based on a? Example: If column a is named Dept and lists: Science, Engineering, Communications...

Hi, I have a problem that I have not been able to solve. I am trying to create a list that cascades in a way similar to the windows start menu. I have read a number of posts on this forum about dependent lists, and have not been able to find the answer I am looking for. If I am...

The goal is for efficiency. The user wants to have the options to: 1. Select component-by-component or, 2. Select a kit. In 7 of 10 times, a Kit is going to be ordered. My thought is to add a dropdown list in Column F that offers: - Component - Kit A - Kit B - Kit C If "Component" is...

I was wondering if anyone on this forum could assist me. I am an attorney (don't hold that against me lol), and I'm setting up an Excel spreadsheet for my small firm's data set. On Sheet1 I have a list of client Names, for example: SHEET 1 COLUMN A Adam Bob Charles Daniel Edward Frank On...