drop

I have a spreadsheet with a drop down list. This drop down list may need to have new entries added. At the bottom of the list, I want another option added, "Add new organisation". When this option is selected, I want someway of adding a new organisation to the list of organisations. How would I...

Dears, i create drop list by using data validation + used Vlookup (VLOOKUP(cell of drop list;the below range;2;FALSE) : <tbody> E drop list ( i need used "All" ) 5 vlookup ( i need all numbers appears ) </tbody> <colgroup><col width="64" style="width:48pt"></colgroup><tbody> </tbody>...

Hi all! I send workbooks out to users and 1 of the sheets is a library of items that is constantly updated. I have the library sheet on Drop Box and users go there and copy it into their workbook. Is it possible to link the library sheet in users workbooks to the library sheet in Drop Box? Thanks!

Hello, I'm trying to filter two tables on a separate worksheet based on a value chosen from a drop down on my first worksheet. Worksheet 1 -Drop Down Reference Cell G2 Worksheet 2 -Table 1 Range B21:Q116. -Filter for column C21 Table 2 Range B122:Q216 -Filter for column C122 Any help is...

Hi, I have searchable drop down lists in F5:F500 referring to a dynamic range in a second sheet. If F5-F500 are clear from input and I expand the drop down list, all options are shown from the dynamic range. If picking McDonald's in F5, all drop down lists F6-F500 displays McDonald's as the...

Hi, I have created a dynamic cell range which is working. If typing "a" in the drop down list, the dynamic range it refers to determines all values containing "a". Now the problem is the drop down list only displays the first four values containing "a" and there is no scroll available to see...

Hi Everyone, I would like to copy data from the "Spreadsheet Archive" sheet intothe "Previous Visits" sheet depending on the station that is selectedfrom the drop down list in the "Input" sheet. I assumed this was going to be a very simple step but my Excel skills arenot as strong as I...

Are there anyway to do drag , drop and replace function on excel? I want to create a dynamic excel presentation on a 3X3 box , not only user will be able to drag and drop the data from Cell 1 to Cell 2 but fill Cell 2 will the data from Cell 1. The function must be able to run on all 9 box and...

Hi, I would like to loop thru all items in a drop down on Sheet1 and copy/paste results to different worksheets in workbook Similar to how Show Report Filter Pages in a Pivot table works. Thanks in advance.

I have done some research and I have not been able to track down any information on the following. Can anyone offer any advise/direction? I want to provide a cell with drop down options that are base on the information entered in another cell. Is this possible in excel 2016 ? Thanks in advance!

I am new at vba. I need to locate the row number of certain employees in every workbooks Employee names are sorted differently and are in another column for some workbooks. Workbook names are located in column AC populated using dir(). From the code below, you will notice that $AC14 is static...

Hello, I would like to know if it's possible to insert a new row if you select from drop down "Insert New Row". All data should shift down and cell where drop downs are should have "Insert New Row" fixed as a selection. Is this possible? Thank you.

I have a cell with a drop down list in it and I want a message box to appear when a certain option is selected from the drop down list. I am pretty sure you can do it with vba but I don't know the code to do so. Can someone help me please?

I am trying to understand how I can create a drop down list that also includes a brief description. For example: Value = 1200 Description = Project Coordination I only need the value but need a description so people know what the value 1200 stands for. Is this something a VBA routine needs...

Good Morning, I seem to be having what appears to be a simple data validation error that I'm confused with. I have a cell that has a drop down list (list is on another sheet). User can scroll through the drop down and choose any of the listings from the other sheet perfect. So here's the...

Morning, I have a cell which is formatted so when it goes into - (minus) figures it turns the cell red, i also have a drop down menu which if "X" is selected from the drop down menu it makes the cell display an "E" with a Green fill, my problem is that when the number is showing minus and i...

Hi All, I want to make a drop down list to pull the data from the month sheets, showing colour box in the Calendar year sheet. But for each Staff is showing only there own data at the time from the drop list. I not sure if I use a "choose formula or match formula", but how do I do it...

Hello I have a dynamic sheet that I am working on that requires a drop down list for multiple cells. I have a table for each drop down list to make the main list searchable as demonstrated here https://www.extendoffice.com/documents/excel/2439-excel-drop-down-list-search.html. The problem is...

I have a sheet that lists out all of our customers. I want to create a dropdown list on a separate sheet that only contains the contacts associated with the company name that is indicated. Is this possible?

Hey guys, I'm running into the issue where I would like to create a drop down in each cell in the range h4:h74, and for each drop down, have each drop down reference a new data set from B86:BT86. So for cell H4, the drop down in that cell should reference B86:some ending point, H5 should...