dropdown lists

Students names ( on normal cells) changed automatically when i select a class from dropdown list : How can i do this via formulas or via vba? for example: "dropdown list " : [Class 6-1 Class 6-2 - Class 6-3 ] Student name 1...

Hello - I've created a timesheet for my employees in Excel. I'd like there to be one particular dropdown menu that shows if the total hours for a day are less than 8.0, and another dropdown to show if the hours are more than 8.0. I know how to do dependent lists, but not how to make a list...

So, I have a formula (see below) to return training in date, upcoming and expiring (RAG). This returns the status for the entire workforce. I need to get it to work against a specific row matching the employee name in a separate drop-down. I'm totally stuck...

Hi, I've created 5 drowndown lists, in columns A to E. The possible options of each list is based off of the selection of the list to it's left. I used data validation =INDIRECT(SUBSTITUTE(D2," ","")) to make this work. What I'm trying to achieve is for column F to give me a certain GL that...

Hi there, I've been struggling with this for a while now. I have found a VBA code that's close to what I want but I do not know how to amend the code so the dropdown data is on a different sheet. On my sheet named "O2" I have a dropdown list in cells F7:F99 which currently correctly shows the...

https://app.box.com/s/m8shnmf18zbawqej3gbx0xms9z00neif How do I get the drop-down icon in the Accounts column to be present all the way down the column and not have to keep dragging it down? I don't know how I got in this situation, like why the icon isn't in the cells where I've added the...

I'm creating a calendar that has specific employees listed in a number of rows and columns corresponding with a date/time. I've used data validation to select the employees needed in these time slots, with the drop downs occurring in many rows and columns. I have found some VBA code that...

Hi Folks, I am working on a spreadsheet to log sales. I have two columns (customers and products) that I've created searchable drop-down lists for (using this method as outlined in youtube videos: https://www.youtube.com/watch?v=vkPoViUhkxU). https://www.youtube.com/watch?v=0QrQT9D25Xk&t=5s...

I have several PDF's that have many tables based on type, size, & year that I need to pull specific data from. The PDF's are company controlled and they send out updated versions whenever the need for change occurs. My quest is to have an excel sheet with drop down lists for the choices listed...

EXCEL2007. I want to create multiple searchable drop down lists, each on a row below the previous one, on the same worksheet, but all using data from the same list. (the list of data is an inventory of a hardware store) the searchable drop down lists , 12 of them, are on the input screen for an...

Hi, I have a dropdown list on one sheet. I want to be able to see that dropdown list on multiple sheets. I also want to be able to change the dropdown list from any of the sheets and this change effects all the related dropdown lists in the workbook. I know that I could use an INDIRECT, but...