dropdown

Hi, I am trying to create a dropdown list based on the results from a filter function. Here's an example : I used Filter function (in B1) to get the results containing the word rose from column D. However this fills the cells B1 to B3, instead I would like to get a dropdown menu. I used...

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

Excel doesn't provide a built-in way to search data validation list. So it could be hard to scroll through the list when the list is long. This searchable data validation+combobox is a way to deal with that problem. It has these behavior: 1. The combobox can appear and hide by certain action e.g...

I want to share a macro to set up multi dependent data validation with vba. Some versions of dependent data validation use formulas to set them up, usually with indirect functions. For 2 or 3 dependent data validation & small data set, it's pretty easy to set it up, but for more than 3, it might...

Hi Guys, I have a drop down list from cells B7:D7, which are dependent and the output is generated in cells B9,B12 & D12. I want somehow for the output results cells (B9,B12 & D12) to become blank if any of the drop downs value changes via VBA. is it possible to do that? Thanks!

I'm having a problem using the sumif formula with a drop down menu selection. I can easily get the cell value based on the drop down selection however I cannot sum the range of the cells. The Day range would be the drop down containing the last 7 days, the last 15 days, the last 30 days etc...

Hello, I have a column containing timestamps. I would like to create a drop down menu in another cell that contains a list of the the distinct month/year combinations in the timestamp column. I know how to copy the distinct values to another column and then create a Validation cell from those...

Hi all, I have a dropdown list on column AY with 'In-Scope' & 'Removed' as the options. If a user selects 'Removed' I wanted to force them to enter free text in column AZ to explain why they selected 'Removed'. Is there any way to do this? The file is also shared. Many thanks

HI All, I found some VBA which created a searchable drop-down menu after double-clicking which worked perfectly fine however now when I use it the drop-down appears I then select the entry and then rather than populating the cell it goes totally blank. Please can someone help me. I have no idea...

Dear community, In Excel, I am building a small database with information on employees, clients, invoices, etc. I have a separate file with some macros that I use to generate invoices. There are 3 things that I would like to have, where the first is required and the other 2 are nice to have...

Hi everyone, I have a macro which edits and populates a template (which has other macros in it) and I need to populate a drop-down value for the month. The value is a numerical value of the current month, so I entered a code which would go to the cell "A15" and populate with the numerical value...

I'm using a standard filter on a run-of-the-mill spreadsheet. I pressed a shortcut key by accident and now my drop down list has moved to the right, almost as if it's right-aligned. This is just an example to illustrate the position of the drop down box. How do I get it back to normal? Thanks

Hi there, I'm new to VBA and Excel. I'm trying to write formula or VBA code to be able to get EXCEL to automatically enter WORK SHIFT based on time when data was selected from dropdown list. I have created dropdown list but now I want EXCEL to enter WORK SHIFT automatically when I select any...

HI Click on the highlighted value in the drop down and help getting the new window <table class="adjustHtmlDropDownWrapper" width="185" height="17" border="0" cellpadding="0" cellspacing="0"> <tbody><tr> <td valign="top" align="left"> <script type="text/javascript"> var MENU_ITEMS...

Hi all, Explaining situation: i have document with two tabs, one tab has data that will sometimes need yes selected from a drop down on two different columns (BB and BC) and sometime yes won't be picked at all in my other tab i have one column and i want it to look to those two columns and if...

Hi All, I'm trying to create a diet plan as i go through the weeks and I would like to stick to one table where if I select the next week, all the cells would go blank and if I switch back to the previous week. I have my data still there. I would like to create a drop down menu of weeks where...

Hello Everyone, I have three drop down at A1 B1 and C1 A1 has value, Apple, Boy and Cat i want if A1 has apple, B1 drop down enable and C1 should disable if A1 has Boy then B1 = disable and C1 = enable if A1 has cat then B1 and C1 should enable Please help.

Hello All, Trying to work out a process to automatically save chargeback detail for a group of vendors based on a drop down filter. It is based on drop down filter because one vendor can return up to 500 lines. At every change in vendor, save what is visibly showing as a PDF. Sometimes what...

Good Afternoon all, I have a list that contains 3 options. Watch option is a statement. I want to highlight a specific word in each statement and then on another tab, be able to select the statement from a dropdown and have the statement come over with the word still highlighted. Is this possible?

Hello, I'm working on a personal project and I have the following problem: I have drop down menus in 13 rows of one column.. These dropdown menus have some overlapping values and some distinct values (on purpose). For example, Row 1 dropdown might have (1, 2, 3, 6, 7), Row 2 (2, 4, 5, 6), Row 3...