If I have a cell that uses a list for drop downs (ie "Make" can be any of several different Fire Alarm Panel Types) and a second cell that I want to use to represent "Model Number" is there an IF the model is A from the Make list, THEN the next cells drop down list represents the model numbers under that Make?
View 2 Replieswhat its called when you have drop down menus that correspond with other drop down menus.
View 2 Replies View RelatedI want to have a spread sheet where a user will pick an option from a drop down list, then based on that option choice, have a different cell populate with a specifc drop down menu.
Example:
Cell A1 has a drop down with three choices (1,2,3)
User selects option 1
Cell B1 will now have a drop down with options A,B,C
However:
If user selects option 2 from A1
Cell B1 will now have a drop down menu with options X,Y,Z
I would like to make a form where the user has to select from a drop down list several options, and that depending on the pick the drop down list below shows different options. example: For the question "what food do you want to eat?" you can select pasta, pizza or dessert.
Now if that person pics dessert, the 2nd drop down menu should shom him again a number of desserts he has to pick. And again below another one depending on what he chose.
I am trying to program a drop down box at the top of a column so that when one of several options in the drop down are selected, a corresponding price list is displayed in the column below.
View 4 Replies View RelatedI am trying to force movement between multiple drop down menus. The menus are independent of one another. I want the user to only be able to select the information in the menus.
View 9 Replies View RelatedI have an excel sheet with Column H having drop down menus for each cell In the column, starting with H5 going downwards.
The drop-down menu contains around 50-70 options, and what I have to do manually is go to h5 and click on the drop-down menu and select the first value. I then go to h6 and click on the drop-down menu and select the second value. I then go to h7 and click on the drop-down menu and select the third value. I then go to h8 and click on the drop-down menu and select the fourth value.....and so on and so on.....until I have chosen all values in the drop down-menu!
Is there a macro that will just do this automatically? Starting with cell h5 get the first value of the drop down menu, go to h6 and get the second value of the drop-down menu and so on until all the values are chosen?
If you manage this one, I also need to do something similar for column K, but this time select the first value of the drop down menu for k5 AND k6, then get the second value of the drop down menu for k7 AND k8, then get the third value from the drop-down menu for k9 AND k10 and so on.
I am trying to create 4 pull down menus. Menus 1, 2, 3, 4. Menu 1 is the top menu, menu 2 will only show certain information based on what was chosen on menu 1. Menu 3 will show certain information based on what was chosen in 2 and 4, again, will only show certain information based on what was chosen in 3. Sort of how the menus on autotrader work, if you chose audi it will only show audi vehicles, although not for the same purpose, or even the same industry. I am using Excel 2007, it might matter. I have attached an xls file that shows the information I am using and below that the basic progression, I haven't listed it all, but you should get the general idea.
View 5 Replies View RelatedI have a very large database, filled with every job we're working on and all the details about it - duties, employees, vehicles, material-costs, etc.
I am currently working on a 1-page "Summary Sheet", that would be used to wade through all of this info and only give me the information I am looking for on one job. I would like to be able to provide drop-down menus on this "Summary Sheet" so that management can pick the information they'd like to see, and not be bombarded by everything else.
Ideally, what I am trying to do is to have a space on top where somebody could enter the name of the job, and then when they pick an item from the drop-down list, it would pull that info from the database via an "Index/Match". When somebody enters a job-name and picks "Joints Tested" from the drop-down, it will only display how many joints were tested on that job.
I already have the drop-downs created, and have other Index/Match formulas in other spreadsheets (they trip me up a bit, but I can generally fiddle with them until they work correctly), but can't figure out how to make it work this way. My database has headings above each column, and I'm writing those same headings next the different options in the drop-down list, but I can't figure it out.
I have two drop down menus: Class Name and Class Period.
Class name returns reading, math, science, or social studies.
Class period returns 1,2,3, 4,5
I need a formula for a cell that will return the name of the first student in whatever criteria is selected by the two drop down menus.
Example: If reading 2 were selected, I would want the name of the first student in reading period 2.
I did start out with nested If's combined with ands, but that is too many nested ifs. I figured there was a better or easier way to do this.
Formula I thought of: =IF(AND(G3="Reading", H3=1), '[Reading 8.xls]Sheet1'!$A6, IF(AND(G3="Reading", H3=2), '[Reading 8.xls]Sheet1'!$D6)) etc.....
But if I use that there would have to be 20 nested ifs, which I think I read someone nested ifs cap at 9.
I am wondering how to create a macro that will untick boxes as well reset drop down menus.
I receive inspection sheets from mechanics and I need to start tracking trends. So, let's say the mechanic has marked an "interior" issue and of the 10 potential items that could related to "interior", he has chosen "dirty upholstery" -
Column A is drop down menu with four categories listed:
Interior
Exterior
Transmission
Undercarriage
So in Column A from the drop down menu I pick the main category of Interior. Then it's on to Column B to choose the exact issue of the Interior. When I choose "Interior" in Column A I would like Column B to automatically show me another drop down list with issues that relate only to Interior (i.e. glass, dirty upholstery, torn upholstery, etc.)
that is question #1....
If there are multiple issues on one vehicle, I would then go to Column C, pick another category (i.e. Transmission) and then in Column D, I would like it to automatically display the drop down menu that relates to Tranmission issues (engine oil, air intake, engine wiring, etc.).
I am compiling questionnaires in Excel and need to constrain the answers. I've successfully used validate, list and directed it to a list (containing, for example, 'USB', 'Firewire', 'SCSI'. When I first set this up, the drop down menu appeared (and the prompt message I had created). After I copied the first worksheet to use as the base for my next questionnaire, the drop down menu disappeared, although the prompt still shows and the validation still works.
Have I missed something fundamental?
I've tried creating one on a brand new workbook and copying the worksheet and it seems to function correctly. Why has my drop down menu vanished???
I am trying to add two drop down menus - part number and material description. I would like to be able to choose an item from either menu and have it populate the rest of the row with the item information.
I know how to create the drop down, but I don't know how to make it work so I can choose from either one of the two drop downs and have the other automatically populate.
i have a table of tools and their properties which i am using to provide validation lists for a number of other worksheets that record when those tools were last calibrated/tested and when they need to be calibrated/tested next.
many tools require more than one form of testing (electrical and/or calibration), but not all tools require both.
can i create some kind of drop-down menu the looks at the tool master list, but only gives the option of those that require the particular type of testing i'm recording on that particular list? how can i create a drop-down list that is more limited than the range i have selected for it to display?
I am using the following code to create a custom command menu.
Sub AddMenus()
Dim cMenu1 As CommandBarControl
Dim cbMainMenuBar As CommandBar
Dim iHelpMenu As Integer
Dim cbcCustomMenu As CommandBarControl
On Error Resume Next
Application.CommandBars("Worksheet Menu Bar").Controls("&New Menu").Delete
On Error Goto 0
Set cbMainMenuBar = Application.CommandBars("Worksheet Menu Bar")..........................
I want to add a new button control at the bottom of the menu underneath the holiday control but it keeps adding it on the sub menu, which leads off the holiday button control. I want the menu to look like this.
Open Net 2 Access
Add Employee
Edit Employee
Delete Employee
Holidays (3 options on sub menu)
*New Control
From this link: [url]
there is some clever code to create a customized menu in a dynamic Add-Ins section of the Excel ribbon; this section disappears when the workbook is deactivated and re-appears when it is activated. The custom menu has 2 main items each of which can launch a macro. There is also a 3rd main item called "Next Menu" which cascades nicely to a sub-menu. That sub-menu can have several items of its own. Very cool code.
However, I am trying to add a 4th item in the main menu, say, "Next Menu2" which also cascades to a sub-menu. The problem I'm having is when I try to replicate this code to accomplish this, "Next Menu2" appears in the sub-menu of "Next Menu", rather than as a separate (4th) main item below "Next Menu".
I believe there was another post (not sure of the date, but has since expired) which asked basically the same question as mine. There was a reply with code saying "This should work" but when I tried it, it didn't help.
I want to create a submenu to an already existing user defined menu.
After creating and saving the sub menu using Tools ->Customize ,it works fine. But when
I reopen the Excel sheet it is not found.
I could not find any macro related to the original User menu.Also this menu gets displayed after the AUTO OPen macro in my excel has worked. This menu gets displayed for only that workbook and not for others.
I have been trying to find out a way to create Sub menu for that ,but could not?
I want to do couple of things here.
1. put an empty field in a drop down box. If possible the empty field should be at the top from the drop down menu.
2. Update names in drop down box when I add names to the list
How to make a drop-down list appear when a cell is double-clicked as opposed to just clicking on the box to the right of the cell that appears when you click in the cell? I want to be able to use the ability to drag-copy the cell contents from the little square in the bottom-right of the cell, but cannot do this when there is a validation drop-down list!!
View 14 Replies View Relatedis it possible to have two criteria possible for one cell?
ie
in cell b16 i have a supplier name
cell e29 is dependant on whats in b16 and calls up from a named range dependant on what b16 is
what i wonder is lets say cell b16 has asda in it
in cell 29 would bring up all the list for the named range asda by this code
I have a spreadsheet with two drop downs, one lets say has country and the other city. When I select a country in the country drop down, I want to be able to only select cities in that country.
I used a method that I found in an earlier post, where I define the name of list of cities of a country to that country and then use the indirect function in city dropdown down validation. The prolem is I can still get mismatched city and country because when I change country, I still have the city from the previous selection untill I drop down and select the city again.
I would like the city to show blank when I change the country until I select a city from that country.
Is there a way to increase the number of items shown in the list when you drop down a validated cell? (I don't want to use a combobox for this).
View 9 Replies View RelatedI named a range State, it contains a list of all the US state abbreviations. I do a data validation that refers to this range as a List. If I type in something that's not in the named range I get the error message I created for the Validation.
But - I don't get a drop down button. I tried to do the same validation on another cell and get the same thing. Other drop downs for validation appear.
I have a range in a worksheet named "Product3" that has data down to row 30 that is linked to drop down boxes on another sheet. I want to add data to rows 31-40 to also show up in the drop downs. How do I extend that range?
View 9 Replies View RelatedI have a list for the user to enter in creditor name, balance, monthly payment and interest rate. In the credior name portion, I have used a Data Validation List (drop down menu of bank names) for the user to choose from.
Later on... The user types in the customers ACTUAL bank acount that they will be making payments from.
If the user types in a bank that is the same as one from the drop down list earlier on, I would like a dialog box to come up with further instructions.
I am trying to create validation drop down list for a cell, however I want different drop down lists which are depenent upon another cell.
in Cell A1, I want the options "A", "B","C" etc
If cell A1 = "A", then drop down validation for cell A2 = 1,2,3,4,5
cell A1 = "B", then drop down in cell A2 now equal 6,7,8,9, 10
cell A1 = "C", then drop down in Cell A2 now equal 11,12,13,14,15
Would anyone know if it is possible to extend the size of the list presented when using the data validation drop down? At present, it seems to default to 8 choices (even though there is a scroll bar) but I was wondering could the list Automatically display, say 20 choices?
View 3 Replies View RelatedI was wondering if there is a way to see all the choices on a drop list. Currently the drop list only shows 8 choices but I am wanting to see all 32 choices eliminating the need to scroll the list. I have attached a picture.
View 4 Replies View RelatedI am doing an internship in Germany, and I have this crazy project with Excel. I am not very familiar with all the equations.
I want to select a company name and a type of container from a drop down menu, and have the information show up on a different sheet assigned for that specific company for the right size container. It involves quantities.
I will attach what I have sofar.
Ladungstraeger(1).xlsx
Ladungstraeger(2).xls