dropdownlist

Hi, I'm currently stuck on my formula for this project. So, I have to cells that both already have a drop down list. What I want to happen is when you choose from the drop down of Cell A, Cell B will be disable. For example: in Cell A the list is: Cat, Dog, Mouse in Cell B the list is: Cheese...

Hello guys, I've created a dropdownlist with company names. With each selection, I got a different calculation for key figures like sales, turnover ratio, Roi and so on. But now, each company got a unique company code (5 digit number). So my question, Is it possible to create a search box...

Hi all, My first time ever posting a question on a forum, but after using google for 2 days to find an answer I have given up on google. And after searching for best excel forum, MrExcel.com came out on top. I hope you can help me with your knowledge. I am trying to use countifs to sort data...

How to create searchable drop down list for multiple cell in excel. I need to import the data sheet in excel, I created a drop-down list with datavalidation but the listbox is too long. Please help me to create searchable drop down list in excel but for multiple cells. Thanks

Please, is it possible to create sublist to groups listed from dropDownList in a combo box such that each group of items selected can have a sub DropDownList? For example if Chocolate represents a group then when selected will display all brands of chocolate in that group. Please help me...

Hello, I would like to know if the following is possible: I have an excel sheet with X different tables, lets say X = 3 A) Is it possible to make a dropdown list (validation list) which shows all the available tables in an excel workbook? Preferable dynamic, so if the amount of tables grows...

Can anyone provide the steps to increase the font size of values in a drop down list? Mine are too small to read. Thanks.

I have a workbook where I perform an advanced filter and from there create a dropdown list. Now I need to have the user select an item from the dropdown list. This selection then needs to be "read" and use this selection to copy the specific items to another workbook. Right now, the only...

im trying to create a dropdown list were for example if i pick "bus-1234" the information under that changes as well. i'm trying to track 1616 buses with ongoing service issues. so i need a 365 rows with 4 columns. "A" will be the column numbers 1-365. "B" column is the date, "C" column is the...

Hi all, I am creating a spreadsheet which show the profits of the month and year. I having troubles doing this spreadsheet. Help me someone. I have a dropdown list, Jan to Dec and Year 2013. I can choose any month or year then the page will show me the profits for the particular month or...

Hi All, I have a problem which I can't get solved. Column C and D are should be picked from a dropdown list (data is in named range on sheet 3). The choices that have t become available in a dropdown list in column E (values also in named rnage on sheet 3) should be based on the combination of...

Hi, I've been searching for an answer to this for a while, but unfortunately when I find anything that looks relevant I don't have any macro/VBA knowledge to really understand what I need to do to the code/parts of code to make a macro that does what I want it to do, so I'm hoping someone can...

Really needs some help. I have 2 worksheet in excel, first worksheet called "inventory", and second worksheet called "consumption". The inventory worksheet is the big list of items that we have in store(ex: apple, mango, grape, orange, carrot, banana etc up to 200 items). In this worksheet...

Hi guys, I've a tricky question here, hoping to get some help. For example; My column A is a drop down list and what I need is when i select an item from the drop list in column A the value in column B will be auto generated. Something like a online registration form. Is this possible?? or...

How do I get excel to filter data based on a selection from a drop down list? I have a table which I want to be filtered based on the selection in the drop down list. Any help appreciated Thanks.

I am trying to do a loop that runs throught all the different tables specified on a drop down list. the range containing the dropdown list is GESTATUS and the worksheet is worksheet 2 (element) is the name of the sheet. How would i go about doing this.