drop-down lists

Hi, I am running into the issue that my drop-down list becomes too long, because there is too much data to work with. We make an export out of an ERP system, which gives us 2 columns(let's call them Columns Chair & Desk) and about 3.000 rows of data. As you can imagine, multiple chairs go...

Hello, I don't have much (read any) real VBA experience. So I can copy and paste code and even start to make sense of it, but I can't create it myself. I have a table of employee data that ranges by month from 2014 through 2016. It also includes teams, unique identifiers, and such. I have...

Hello all, I am attempting to figure out a problem and I seem to be stuck. What I am trying to do is create a drop-down list for different tabs in my worksheet. When a tab name is selected I want it to automatically direct me to that worksheet. When I am directed to a worksheet I want another...

I've been racking my brain trying to figure how to solve this for the last week and a half. The core of my formula works in Excel but not in VBA. The basic concept I'm trying to accomplish is to make one drop-down dependent on the result of another drop-down. The first drop-down has a list of...

I have a list of 246 countries. I have 10 drop-down lists, allowing the user to select 10 different countries. I have assigned each country with the corresponding number they have in the drop-down list for ease of programming. After the selection has been made, the user will click on a...

I am a 5th grade teacher developing a lesson plan template for myself & for my elementary work colleagues. We are now required to include the Common Core State Standards (CCSS) in our weekly lesson plans. To help with this task, I am working on a template using Excel wherein the teacher can look...

Good day Demigods, Hypothetically, In Cell A2, depending on what has been chosen in Cell A1, the following four outcomes can be displayed: Yellow Blue Date Numbers In Cell B2, the following needs to happen If Yellow is selected, a drop-down list is populated with data from column A on...

I actually have a two part question of which I am sure the answer to the first question is no. Can I create a drop-down list from a series of cells that has a blank cell or two in the middle? DROP DOWN CELLS Option 1 Option 2 Option 3 Option 4 My second question is why I am here. How can I...

I've got an XLS* with several drop-down lists (from an adjoining tab). When I populate any of the drop-down cells, the remaining non-drop-down cells (using keybd shortcut Alt-down-arrow) have a "virtual" drop-down list of the values of the above cells. Perhaps there's a handy use for this...