drop down list

Hi there, I need to create a few dependent drop down lists driven from the results based on Customers. Example: Customers: Honda, Ford, GM, Vovlo, etc... Honda Plants: HCM, HMIN, KTH,KSM, MAP Honda Programs: Accord, Civic, CRV Ford Plants: Monroe, Dearborn, LAP, KCAP For Programs: V363...

Hi all, Hopefully there is a simple way of doing this, as I feel embarrassed that I have failed to this point. A simple example would be a table with three columns - State, County, and City with 500 records (500 unique cities, 100 counties and 50 states) I need thee drop downs, each based on...

I got such great help earlier today, I thought I'd ask for another favor. Scouring for answers didn't seem to help. So my situation is, I've created a drop down in B1 that has 4 options. Each option has a records retention rate associated with it. I would like cell B2 to reflect that rate based...

I need to add a kind of advanced comments to cell in a worksheet. Say if I click in cell A2 and press a button, a pop up appears that allows me to add comments. The pop needs three values, 1. A drop down menu of two options (D1, D2), 2. Text comment, 3. Text comment. Afterwards, when the...

I have a drop down list with 4 options - A, B, C, and D. I need that only when C is selected from the list, the cell itself has a hyperlink. So, if cell B4 gets the value C from the drop down list, then C or the cell itself should be hyperlinked to say Google.com. If any other value is selected...

Hello... I wish to have a command button that can hide/unhide with various safe file option based on drop down list value in G6. Here is a table: <hide command="" button=""><unhide command="" button="" and="" save="" file="" only=""><unhide command="" button="" and="" save="" &="" close=""...

Hi all. Picture this if you can, in sheet 1, cell A5 to C6 has a data validation drop down list containing MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY. First of all I want copy whichever day I select in to a set cell on sheet 2, for some reason when I click = cell A5 i get the #VALUE ! error...

Hello friends, I'm new to this forum, I'm just a noob in excel. I would like to get some help from you creating a bill for my profession. I work as a freelance tour guide, my bill has different pricing according to the different tours. Like from Particulars from Si no. 3 I should have a drop...

Hi all I have a populated data base where each row represents a customer, and each column represents a product. Some columns are subdivided where a product has variants. All I want to do is create a simple worksheet where a product can be selected from a drop down list, and then all the...

I have a table with one of the columns having a drop down list with 9 options. The drop down list takes it's options from a list elsewhere in the spreadsheet, as standard. I understand how conditional formatting data bars works, using numbers in a range and filling out the bar based on the...

I'm wanting to input data to a cell then run a macro that will transfer that data to a table elsewhere on the sheet. Which list in the table it gets added to is dependant a drop down list that is selected. That's the jist of it at least... Onwards! Cell C2 contains the drop down list that has...

I have a macro that clear the data from some specific cells and i want it to be trigger every time a change the option from a drop down list. How could I do that? thanks!

Hi Guy's I am very new to VBA and i am struggling with a code based on the option which are selected from the drop-down list. Drop down list is in column D in the sheet "MyData". Columns A-C will be populated with data. What I want to do is: if option "Terminate" or "End" are chosen from the...

What is better for memory management pivot tables that feed into a dashboard for slicers and pivot charts or a dynamic drop down list that populates the same information to a chart? I was also wondering does anyone have a solution to auto-refreshing a pivot table and pivot chart when new data is...

So I'm working with a spreadsheet I didn't create, but I need to add information to a drop down list. I went to Data->Data Validation and this is what it's telling me is the source.. =F9_Hidden_Lists!$A$2:$A$20 Thing is...I don't know where this "F9_Hidden_Lists" is at. I have made sure to...

I'm doing order form. I would like to be sure that always after use of drop down list of products, quantity od them will be enter by user. a1..a30 drop down list of products in every cell ( that part I know how to do) b1..b30 quantity to be put by user (1-100) User is choosing product form...

Hi all I'm trying to copy a selection from one worksheet and paste it to another. The range varies depending on the time of the month, and so I only need to copy data up until the first blank row. I have a simple code to do this, however I think its seeing a blank drop-down cell as live cell...

Hi, having never used Macros before I wanted to use one to be able to multi-select options from a dropdown list in Column C. Having googled, some kind person had posted the VBA code and I opened the VBA editor, pasted it in and hey presto it worked! (See code below question). Anyway, I then...

I have a combox box that allows me to select a worksheet name from a drop down list and then it takes me to that worksheet. That part is awesome. It works in conjunction with a command button. The command button generates the combobox with the worksheet names. This part is not awesome. My goal...

I have 3 drop down lists. The first cell is the product, second cell is the make and third cell is the model. Cell 2 is dependent on cell 1 and cell 3 is dependent on cell 2 However, when I delete the first cell I want the remaining two to reset back to empty. The only way that is possible...