drop down

Hello guys! Need some quick help here. I want to make a drop down list which shows data from "Column A" when selecting but enter the corresponding value from "Column B" when selected. I hope I made myself clear :) For example, this is "sheet2" Column A - Column B 1947 - 500 1948...

System: Windows 7 Professional 64-bit Software: Excel 2013 Greetings Everyone! I have been trying to manipulate snippets of code here and there to find a solution to this project. I wouldn't say that I'm a VBA novice, as I am not actively trying to code, rather than see what works from other's...

Hi all I'm hoping someone can help. Look all over for a solution but no look. Now I'm pretty proficient with Excel and not bad at VBA (still refreshing my skills) bit I'm stuck! Let me try to explain. I want a cell to autopopulate with M or F for gender if the group looks like this 10CS-B or...

The goal is to use a formula to get a particular e_c value in a cell and a particular e_a value in a another cell given the three logical tests which are E_a (either E_a < 0.5E_C or E_a > 0.5E_C), Class (1,2 or 3) and Repair Lifetime (Any Value rounded up to 2, 10 or 20 years). I understand that...

I have a drop down menu and corresponding macros for people to navigate around a large workbook, my question is before the macro runs to take them to the appropriate tab can it return the Drop Down to say MENU (essentially returning it to a resting state) Private Sub Worksheet_Change(ByVal...

Hello I am creating a questionnaire which comprises of three excel worksheets. On the first worksheet one of the questions has a yes/no answer in a dropdown. I want to automatically select a worksheet depending on the answer to the question For example: If someone selects yes they are...

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

In Sheet 1, the user would would be choosing the options in the dropdown. I'm not sure whether to use a data validation drop down or a combo box to achieve my goals and how to do it. The items in the dropdown list is located on Sheet 2. The length of the dropdown list will change as new items...

Is there a way for Excel to clear certain cells, depending on a date in the drop down. I do head counts of different areas in the building I work in. I would like it all to be on one sheet. Is there an easy way to do this? This is what I'm currently working with: <attachment></attachment>...

i have a dropdown in A1 which is 2 companies, i have data for these companies on 2 separate worksheets. what i would like is, if A1 =company 1 i could have a vlookup for that sheet in tabs A4:D4, but if A1 = company 2 a vlookup to that sheet would be needed for the same range. i have looked at...

I have a file with drop downs. The goal is to remind users to enter a response in column K (root cause) if the option "Employee Error" is chosen from the drop down in column H (Cause). How do I make a message box appear saying "Please enter a root cause" once a user chooses "Employee Error" in...

Selecting item(product) from Drop Down List auto fills 4 cells below it with items ( competitor products) that are similar(generic) to product selected in the drop down.

I want to have a drop down menu and if something is selected from that drop down menu to display only certain information. I have the drop down menu in place, but cannot figure out how to display correct information. i was tying to use and IF formula. But I don't know if this is the best...

Hello Hello I have a spreadsheet with a huge list of parts, It is broken down into Category, Subcategory, and Sales Description. I have been trying to use data validation on a separate sheet to build a parts list of my choosing from the huge master list. I can filter the Category and then...

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 All, I have a large spreadsheet to track all my data. In one column I have a drop down menu that contains five options (Accepted, declined, on hold, TBC & Cancelled). When I create a pivot table I can only get one of these criteria to appear at a time and have to filter through using a...

Hi, This is my first post, although I've been reading the forum for quite some time. I have what I thought should be a pretty simple problem, but for some reason, I'm stuck on it and can't seem to find anything out there that explains my scenario exactly. :-x What I'm trying to...

Greetings. I have an excel sheet that has 2 drop down items that are linked together. When choosing a value in 1 drop down the other drop down value updates accordingly. What I have done is attach the Speech application macro to each of the drop downs (same macro for each) that speaks the values...

It's been a few years since VBA class so please respond as if you were writing in an "Excel VBA for Dummies" book. In column G, each cell in range G2:G1001 is an individual data validation drop down list of all the worksheets in my workbook. I have a macro that when you select "Questar" from...

Hi, I wanted a simple macro that selects an item from a drop down menu in cell b3 (causing the summary sheet to change), prints the summary range, pdfs the sheet, and then saves it named as a certain cell (g3). Thank you so much! I'm really struggling!