drop down

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!

Hi, I am creating a master register for internal business documents, each shall have their own unique document number. I have a dropdown for cells under DIV and DOC, with list parameters on separate datasheet. I have a partial formula within DOCUMENT NUMBER column of =($A2&"-"&$B2&"-"&$C2)...

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

Hello, I do not know much about excel I'm afraid and have been given a task at work but unfortunately am struggling big time - tried to google it and read through several websites with no success. I have a spread sheet with lots of different projects on - I created a drop down menu where I...

Hey guy, I am trying to perform some web scraping, but I cannot get the dropdown list filled. I already serached many websites and forums without any success. In the code below I demonstrate some of the attempts that I have tried unsuccessfully, but doesn't mean that I ran the code that way...

I have a two-part table (both sides include the same headers), the one on the right (columns B to F) includes drop down menus, and the second (columns G to K) has a letter "U" (looks like a square in wingdings) if something is selected from the corresponding drop down menu, otherwise they remain...