drop-down list

Hello guys, I am trying to create a dependent drop-down list in a table range that is dependent on what the user chooses in the first column. The data for the drop down lists are stored in another table on another sheet. Imagine that the table below is formatted as a table range (Formatted as...

I'm just learning to improve my VBA skills. Made lots of progress yesterday but now I find myself faced with a momentary wall... My dilema: I have two sets of data in Sheet2: one set in array AT1:BU2000 and the second in array AB1:AR2000. There is a drop-down menu in Sheet 1 containing a list...

Hello! I have an online satisfaction survey that I give out to customers. Each month I export the responses from the software as an excel file. However, I also have a separate excel file that is used for tracking purposes. I have been manually inputting the data into the tracking spreadsheet...

Hello, I am trying to create a drop-down list based on a (rather complicated) formula, and since the validation rule won't accept a formula, I'm not sure how to proceed. Essentially, I am trying to create a spreadsheet for scheduling staff in various locations, based on their qualifications and...

Hi, I'm very new to VBA programming and I'm not yet able to put together a macro I need :eeek:. I'm not quite sure even where to get started. I'd like to create VBA Macro that allows a blank cell to be set a value via its drop-down list then take each subsequent value selected via the same...

Hi all, I have a question about sorting that I have not been able to find the answer to. Using Excel 2010 My problem: I would like to sort a large table ('Participant Table'!A1:AG47638) based on a value of around 50 different values in drop down list ('Choose your Location'!G7), which matches...

Hello ~ I am trying to figure out if a macro is possible at all to run through all items in a drop down list. Here is my example: - Drop-down list in cell B3, which selects 5 possible countries in a range defined as "country"; - When I change my selection in the drop-down list, revenue (just...

Hi I've created a number of conditional drop-down lists in a userform. Where the section made in one field will affect the list that's returned in another. Now most of the lists are working fine but there's just this one that is unrelenting and refusing to work. When you click on the drop-down...

Can someone please help me to create a drop-down list using VBA in Excel 2007? I want to have a drop-down list of values (7 in total, 2 words each). Once the particular value is selected the macro writes a value category (3 categories, 2 words each) into a specific cell as well as the value...

So I have a Sheet, where I want to show only the data which is relevant based on the user's selection in the drop-down list (G3). My code so-far: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("G3")) Is Nothing Then Application.Run "HideRows" End If End Sub...

Hi all, I have a question concerning drop-down list and error message. I have two lists (range name: Status1 and Status2), the lists to be shown in cell A2 depends on wether cell B2 is empty or not (in B2 user can write what he wants, no drop-down list). To create the drop-down list in cell A2...

Hey guys, I have seen a few other threads on this topic but not quite the same. I have an excel workbook which contains each month on a separate sheet. On each sheet it has each week and the hours I have spent at work per week. I have to fill out a timesheet eachweek and send to my work in...

Hi everyone, I am looking for help regarding conditional drop-down lists. Here is the scenario I am looking for: Cell A1: Has a drop-down menu defined by Data Validation list from a separate sheet. For the sake of argument, say the choices are "a", "b", "c", "d", "e", "f", and "g". Cell...

Hi all, I am new to coding on excel using VB. I have created a drop-down macro by referring to many codes available online. However, my user may want to put a choice outside the options provided in the drop down. Any idea how to allow for user input? Would really appreciate some help.

I'm creating a deal tracking spreadsheet with several columns of customer information. In the last column, I want to have a drop-down list so that the sales team can choose either: Deal Won, Deal Lost, Quoting. In addition, I'd like for the entire row to change colors based on the value they...

Before… Summary table by using filters. After...

Using EXCEL 2007, Windows Vista (32). I want to be able to place a reference in a formula to a cell containing a drop- down list so that the name in the drop-down list will replace the name (on another worksheet tab) to enable me to call up the data in the cell in the formula. Say I have...

Excel 2003 Rows 1-11 make up a heading with cells A-I merged variously. Starting at row 12 every cell in column A has a drop-down list, and column B is formatted for date, conditional formatting so that if the date is prior to today it is highlighted red. I need to add a column in between A and...

Here's what I have: In Workbook "Item Tool", I have successfully linked (by Name reference only) a data validation drop down list to another Workbook "Item Database". Both separate files of course. From Workbook "Item Tool", the column "Brand-Model" is a data validation list of all unique...

I know there is probably a simple way to do this, but I'm new to VBA. I have multiple drop-down lists and for some I am trying to unhide rows if a specific drop-down item is selected and rehide them if the drop-down item is later changed. For example, if in row 17 "Red" is selected, rows 18 and...