drop down

Hi. Am confused here. I would like to create a data validation drop down list that when one of 4 things are selected, it brings up another list, select an option and bring up a final list. Example: Drop down list one would have Region 1, Region 2, Region 3, Region 4. By selecting Region 2, it...

I need a conditional format- the one I know will not work :( Here is what I need: IF i8 says "beaumont" then I need the numbers in L8 to copy over into T8 another example If i11 contains "Ocala" I need the numbers that are put into L11 to copy over into T11 Tried this and it does not work...

I have a code that logs in to a website as it should but when it goes to click into a drop down menu it errors "Method 'Document' of object 'IWebBrowser 2' failed" and errors on this line IE.Document.getElementsByClassName("MenuBar_Menu")(1).Click Here is the full code: Sub test()...

Hello all, I found a thread which covers my need, however it is limited for 3 columns and I need at least 5. In the thread he say it is difficult to set up it, so I would like to know if you could help me on that. Example Thread

Hello, the good example of drop down list is here: Prevent duplicates in cells where there is a dropdown list It is not working when typing allowed value, for example "peaches" and pressing enter on the keyboard. The value "peaches" is accepted when it is choose directly from the list or...

Hi all, First post here. I have a spreadsheet which is trying to do the following: User makes a location selection from drop down list User hits macro button on the "Test Recording" sheet Button should start by looking at the location selection in the drop down list, and then pulling data...

I have a list of items in a spreadsheet which are maintained by a designated person to ensure they are current and applicable. I have created a pdf form which is pretty much empty apart from simple things like an email address, logo. I want a different designated person to open that form and...

Hey everyone, how are you all doing? This is my first time here, so please be gentle. No, but seriously, I need help. I want to know if it's possible to create a drop-down list that provides an option for someone to click and begin to type a custom response in the space. Thanks guys!

Hi, I'm using VBA as a drop down so that when I click on the selection it hides all columns except for the ones I need to see for that criteria. My problem is that once I have selected one of the options e.g Newcastle, to see the next option e.g. Carlisle, I have to go back to Select College...

Hi All, I have a data analysis sheet that Im currently working on. I have a drop down list with different entries and I want my code to a copy specific cells (C102:G105) and depending on the drop down menu selection change the paste location of cell in different sheet. I have some of the code...

Hi! I am having a difficult time figuring if I need a VBA for this as I have a source or list with all the items and each cell, I want to select some of the items into a drop down list is that possible? Thank you.

Hi, Sorry in advance if this doesn't make sense! I am hoping someone can assist, I am currently building a Microsoft Access Database for my workplace to keep track of employees and their movements (e.g. Team Changes). I am trying to create an Employee Details Form like in the Student \ Time...

Hello! I'm extremely new to all of this and I am trying to create a drop down menu that will allow me to make multiple selections plus show any results that contain the selected option in any way. D12Order3Urine culture4Urine culture5Urine culture6Throat Culture7Throat Culture8HIV screen, RPR...

Hi there, I have a sheet named Workers with 2 columns. Each column has around 1000 rows. Under the column Shift (B clomun) there are only 3 options: mornig, evening, afternoon. Under the column Name (A column) are names of workers (example below). Name Shift John morning Paul evening...

Hi all, I am trying to have my spreadsheet show costs for running a stadium based on two inputs - Crowd Size and Zones Active. On Sheet One I have two drop down lists - Crowd Size and Zones Active. I also have a Total Cost cell where I require the output. On Sheet Two I have my data set -...

Good day, Regular excel I am needing assistance with the following issues. I have three sheets with data in them, the first one has a list of golf courses, the second has the courses (the name, par, slope, rating). On the third sheet is where I would like to enter the data as I played. Col A the...

I'm fairly new to excel. I have googled this with no help. I will try to explain this the best way I can. I have a field that I created a dropdown from a named range. I then want to use the value selected to create another dropdown list, but its filtered to only display certain values from the...

I have a problem, want to mirror a drop down list on 2 sheets so that when one or other is changed they both change to that same value I have created the first drop down list using DATA VALIDATION from a table on another sheet. I have then gone on to my second sheet where I want the mirrored...

Hi all, I want to create a sheet where there will be a drop down list on first column and a second connected to first one on the next column. Once I select a value on the first one, I want the next column to bring up the relevant drop down list from predetermined values ( essentially the first...

I have drop down I am trying to count and limit the number of times certain values can be selected. The worksheet is setup like this: Name Role Alex Clerk Jim Admin Stacey Developer Mike Analyst Chris Pool The Position column has...