drop down list

I would like to subtract a number according to Drop Down list options. My Drop Down list is in colums B4 to B20 and each column has the same tree options: A-B-C , and there are columns D4 to D20 and F4 to F20 each column with numbers in reference to those options. Columns G4 TO G20 are the...

Hi all, I've been looking up how to do this online, and I haven't had much success, so hopefully someone can point me in the right direction. I am trying to create a few drop down boxes on a userform, and am trying to make the values a range from my sheet. The three drop downs will be for...

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...