drop

ws2.Range("D3").Value = Application.WorksheetFunction.Match(variable_i, ws2.Range("A:A"), 0) ws1 = worksheet 1 ws2 = worksheet 2 On ws1 I have 2 columns of drop down boxes (data validation list) the selection from the first column of drop down boxes is assigned to the variable "variable_i"...

I thought I had enquired about this but after going through my posts & not finding it I assume that I then didn’t. As per title. My drop down list has a blank entry at the the top of the available names to select from. I would like to know how this blank entry can be selected when the...

Hello I want if there is a change in price it should reflect in new records only but should not disturb the previous records with old prices. a link of my file in the drop box is given below. https://www.dropbox.com/s/uq3fyn1snj1ah5y/salarzai%20petroleum.xlsm?dl=0 Password for opening/...

Hi, Is it possible for a simple code for which when the worksheet is open the first entry in the drop down list is selected. have a nice day.

Hi, I am on a webpage where there is a dropdown list to identify the applications to 'Download To'. When I manually select the 'Microsoft Excel (XLS)' option (which happens to be the first in the list), then the 'Dates From' and 'Dates To' input boxes are then displayed. However, when I...

I am creating an order form that allows users to select items from a drop down. I want a pop up to show up when they order the same item more than once. I have the following formula for the Data Validation (list) for the drop down...

I am attempting to create a form in Excel for our sales to to request quotes to our office. I currently have a list of products in a drop down and each of those items require additional cells to be completed. Is it possible to create an if/then from a drop down that would unhide the additional...

So I have tried so many different ways before reaching out to you guys. Is there anyway to have a CSV file with leading zeros in a number field that will not drop the zero when reopening the file?!

Hey everyone, Does anyone know how to use illegal characters in a Drop down? I have looked it up, but everything I have read went over my head. I have a a drop down that is dependent on a drop down. In the first drop down I have a few fractions that need to be options. Thanks for the help.

Hey everyone, I have a button which clears all of the drop downs on my sheet ("Sheet1"). I would like to have the button also set the first drop to go to a blank option, which I already have made. Is there a way to make the drop down select it? Thanks in advance.

Help please :) I have a invoice prepared and i am looking to have a part number from a drop down list but then want show in another column the description generated by the part number. Any help would be greatly appreciated Regards,

Hi, This morning i came to use the drop down list but nothing happened. If i select the cell then data validation i see the following, SETTINGS Allow LIST which is correct Source =HONDANUMBERS which is correct I click on OK but see an error message The source currently evaluates to an error...

Hey everyone, So in my worksheet I have a lot of drop downs. Some are dependent on some are not. A few of the rows I have hide if "No" is selected in the drop down. After I use another drop down, the row un-hides itself. Does anyone have a solution to this issue? Thanks in advance. Here is a...

how to Conditional format a cell with a drop down list with a different text value depending on another cell which has a date entered. <tbody> A B 1 2 </tbody> If A1:Z1 uses a drop down list containing multiple items ie. review, checked, completed and B1 has a date which is manually...

Hello Friends, I am using the below formula in data validation to get the dependent drop down list =OFFSET('SIZE ORDER'!$B$1,MATCH(A2,so_ref_no,0),0,COUNTIF(so_ref_no,A2),1) I just want to add another criteria Match(C2,so_size Please if anyone can add the 2nd criteria in the above formula...

Hii, I am trying to create a sheet that would track samples distribution to customers. In the attached sheet under the Tracking Sheet tab I've set the "HCP" column to be a drop down menu to avoid miss spelling names. I want to avoid miss spelling names so the pivot table would be accurate...

Hi, Is there a way to set up Name Manager to change the Name of the sets in Name Manager automatically so it will allow the drop down lists to continue to work? Thanks Angus

Hi, I am using Indirect Drop Down lists for my project. =indirect(e30) etc. I have a rage of name ranges in the name manager. I am using this sort of formula to adjust the lists as things are added or removed: =Sheet1!$C$2:INDEX(Sheet1!$C$2:$C$1000,SUMPRODUCT(--(Sheet1!$C$2:$C$1000<>""))) My...

Hi, I have a userform with multiple comboboxes on, but i'm having trouble with one in particular. When clicking the drop down, it lists the two items from the named range. But when i select an item, the userform will then show either 0 or 1 (rather than the words "Single" or "Multiple" from...

Hello, wondering if someone can help me, I think this will be a relatively simple question for someone. I have a UserForm with drop downs for Department and Name. I have an ever growing and changing list of Names in a sheet called ‘Staff Database’. This contains columns Department, Name and...