drop down list

I have a set of named ranges. In range A1:A2 two of these named ranges are listed. In range B1:B2 i want to make a drop down list, with a list dependent on what named range are specified in the cell to the left, either A1 or A2. I create the lists successfully, and record my actions using macro...

I'm having trouble formatting a single cell. The cell has an index match formula in it based on a drop down list: In cell F1 --> I want it to show RED for Janet but GREEN for Ben or Adam, depending on which name I pick in the drop-down list (cell E1 is a drop down list). Right now, I have an...

Cell B8 can be blank, Yes or No. When B8 is Yes, I need my data validation list to appear in fields G28:G35. This is simple and I have my listed named Status. When B9 is No, I need N/A to automatically populate in fields G28:G35. I also need these cells locked. I found some VBA help topics but...

Hello, Is it possible to have a drop down list that if, for example, you select option A it generates a group of X lines beneath it but if you then change to option B it modifies the grouped lines to more or less, depending on what you need, and if you remove the option (or choose the empty...

Hello guys, I created a searchable drop down list on excel and i want to duplicate it about 10 times, but when i do it, excel considers the 10 copies at one so when i choose an option in one of them, this same option is selected in the ten drop down list. How can this be fixed? should i create...

ColumnA ColumnB ColumnC ColumnD ColumnE ProdID ProdName ProdDesc Active? For DropDownList ID1 Item1 ProdDesc1 Yes Item1 ID2...

Hi all, So I'm looking to set range variables equal to corresponding lists to create a data validation drop down. I want the data validation cells on my homepage sheet, titled "Input Sheet" and the data lists on a hidden sheet titled "Data Validation". Here's my current code: Dim Rng1 as...

Hello all, longtime lurker, first time poster here. Background: My work uses a survey-based system to "grade" our store on its customer service so to say. There are 5 metrics that we are graded on, and they calculate the scores based on the averages derived from our weekly surveys. I have...

I have code that adds a drop down list to certain cells. I want the user to be able to leave a drop down list blank. What I am having trouble with is writing an if statement that skips a blank cell with a drop down list. So if Cell(1, 2) has a drop down list and the user leaves it blank, what...

Hi all, I'm new to the forum so apologies beforehand for any errors while posting this. I'm also very new to VBA coding, but looked around and eventually put together the below code from various sources, with some flaws though. My requirements with the coding are: 1) Select multiple items...

I am so close to solving my excel problem, but can't seem to break past this final step - someone please help, it has been going on for three weeks now in my search for an answer! I have a workbook where sheet1 is a table of 4 columns, each has a title of Item #, MFG, Model, Qty. Sheet2 is not a...

I have a large worksheet with four columns (A, B, C, D) with the titles: Item #, MFG, Model, Qty. There are about a 1000 items in total, which means each of these columns has a 1000 cells each. My goal is to create a second worksheet which is blank but has the same titles. I want a drop down...

I'm currently trying to make column of lists (starting in D2 and going well into the D500's) that are dependent on a list in the corresponding C column. So for example: A___B___C (1st list)_____D (list dependent on 1st list) ... __...____ Supplies____ Erasers ... __...____ Supplies____ Pencils...

Hi, I've been trying to create a drop down list using the following formula where PROJECTLIST = LISTS!$G$2:$G$71 or G:G (I have tried both) If I just use the PROJECTLIST array for the drop down list it shows everything, if I use the formula below it only returns 47 entries - is there a limit to...

Hello, Does anyone know how to auto populate a cell from a large drop down list? E.g. There are circa 200 people on this list. It would be good so when I start typing the first few letters it auto populates. I should be grateful for any help with this please? Thanks in advance. JC

When it comes to Excel my wife is a true novice. Her company generates daily reports on the retail stores she oversees and I’ve created an excel sheet that allows her to easily copy the data into the data sheet and some pivot tables for her to easily capture sales figures by day, week, or...

I want to hide certain rows based on a selection from a drop-down list. My code so far: Private Sub Worksheet_Change(ByVal Target As Range) If Cells(10, 8).Value = "Yes" Then 'ActiveSheet.Unprotect Rows("11:12").Hidden = False 'ActiveSheet.Protect , DrawingObjects:=True, Contents:=True...

Hi, I am looking to auto populate a spread sheet using multiple drop down lists, 4 to be exact. It is a dimensional drawing of a tool, where the dimensions will change when a different size and weight and material is selected from the drop down list. Please let me know if you can help me out...

Hello Everyone!.. This is a bit challenging for me so i was wondering if anyone can help me out with this. I have read lots of threads about DV autocompletion and people wanting to have in it. Well my question is somewhere in the same field. I have 2 active sheets where one is has a DV based...

Good day all, </SPAN> </SPAN> At the moment I am working on a project to create quotations. </SPAN></SPAN> I have one “Fill in” file, which will be used by several people. This file consists of Cells which have to be filled in, drop down functions and Active X Controls (drop down functions)...