Dependent Combo Box Glitch
Sep 25, 2006
I have a sheet with two combo boxes. One lists RC's (Responsiblilty Centers) and the other lists the Departments depending on which RC the user chooses in list one. I am not sure I did this right because a user choose a certain department and Department Drop Down List for some reason is now limited to the School of Nursing departments related to the user’s entry on the contract log. All the department field drop downs for entire sheet are now restricted to the information related to Dave’s School of Nursing RC on Line 1 & 2.
View 6 Replies
ADVERTISEMENT
Oct 9, 2008
The first combo box is on a userform so that a subject can be selected
View 3 Replies
View Related
Jan 22, 2010
Situation:
I have two drop down lists 1) Country and 2) States/province
Country has list: [US, Canada]
If "US" is selected, [Arizona ,Florida, NewYork] is listed in the 2nd drop down list
If "Canada" is selected, [Alberta, Ontario, Quebec] is listed in the 2nd drop down list
Scenario:
First, I select "US" and choose the states to "Florida"
Next I change the country to "Canada" and forgot to choose province
Then, the 2nd dropdown list is changed to [Alberta, Ontario, Quebec],
BUT the current value is still "Florida"
Probem:
Now I have "Canada" and "Florida" selected in the sheet
Question:
If the primary list is changed, can I make the 2nd drop down list to show a default value (e.g. blank or the first entry i.e. Alberta)?
View 11 Replies
View Related
Sep 19, 2009
I want to make a combo box in excel that, if i select it the sheet inside the combo box will appear.
Example:
Inside of combox are: Sheet1
Sheet2
Sheet3
If i click combo box and i choose sheet3 the sheet3 will appear.
How can i do this? theirs a macro code to use?
View 9 Replies
View Related
Oct 19, 2008
I have to create two combo boxes and when a user selects a value from one combo box, the values should get changed in the other combo box.
For example : if one combo box has values like "c/c++ programming" "java programming" and so on.. ... i would like to display the authors recommended (corresponding to combo box1) in the combo box 2.
View 6 Replies
View Related
Feb 1, 2007
I would like to create a combo box however the contents of the combo box depends on what i have selected in a previous combo box.
View 2 Replies
View Related
Feb 19, 2010
firstly in cell b2 i have to select a quoted time
then in b3 i have to select a type
so dependant on what is in these cells
should return answers in cells e2:e5
ie
if i select1-3 weeks in b2 and s/o in b3 it should then look up 2 in the yellow cells and return the answers day1 day3 day8 and day14 in cells e2:e5
View 4 Replies
View Related
Feb 19, 2009
Is there any chance someone could post an example file for this? I cannot figure out how to set it up.
View 14 Replies
View Related
Dec 30, 2009
I am trying to wrap my brain around dependant dropdowns and have hit a brick wall.
Using the Contextures web site [url="http://www.contextures.com/xlDataVal02.html#TwoWord"] I can get part of the problem to work but when I try to add a third dropdown i get lost. Attached is a sample of the workbook.
View 5 Replies
View Related
Jun 27, 2005
I've created a dependent list in Excel using Data validation. The first list is independent and the second list depends on the first list. I'm facing one problem in this. After selecting a element in first list and corresponding element in second list, if I want to change the first list again, I can go and change the value. But the value in the second list remains the same. I want the second list to be empty when I' selecting the first list again. How can I do this?
View 14 Replies
View Related
Feb 8, 2014
Is it possible to use dependent combo boxes in user form?
For example I have three country name
USA Germany Italy
I want to choose one of them and then my choose be restricted to chosen country cities
When I select Italy in combobox1 i see just Milan and Rome in combobox2
If I select USA I see new york Los Angeles and ...
besides
I wants to see each of these dependent city telephone codes in textbox2 ( kind of vlookup that work with dependent comboboxes).
View 9 Replies
View Related
Jan 27, 2014
how to make make cell D4 dependent on the value in cell D3. So if cell D3 = 10 (it's max), then cell D4 could equal 0-10. I want to use this in conjunction with Solver so that D4 is a variable, but can't be greater than zero until D3 is maxed out. I've already tried different formulas, but I'm not very good at writing them and data validation didn't seem to work either.
View 2 Replies
View Related
Mar 11, 2009
I have two columns with correlating data. i created a validation drop down list and would like the corresponding number to populate a cell based on the drop down list selection. i.e....
View 2 Replies
View Related
Apr 10, 2009
Firstly I have these 12 values as in the attached excel sheet (in the order: FY09, FY09Q4, FY09H1, FY09H2, FY10, FY10Q1, FY10Q2, FY10Q3, FY10Q4, FY10H1, FY10H2, FY11Q1) to be selected as Start Date and End Date. The Limitation on Start and End Date is that the End Date cannot be smaller than Start Date (for e.g.: If start Date is FY09Q4 the End Date can be FY09Q4 and above but not FY09). Now I have a separate set of Initiatives/Objectives for each time period (each Initiatives are marked in excel sheet 2) and Initiatives depend upon Start Date Selected so once Start Date is selected only the related List of Initiatives should be published.
Now the Validation and Naming I have used is not allowing me to use a list name as “FY09” and “FY10” as they are cell references in the Workbook. But I cannot also change the name to something as FY_09 as the data that would be there in the Template will finally be used without editing for upload to an application.
View 3 Replies
View Related
Jul 6, 2009
I have been searching on this for a little while now but have not been able to find a solution to my problem. I have been asked to create a series of dependent dropdown lists using excel so that we can use these for inventory imports into a asset system. The catch on this is that nobody here really has any idea on how to make these dependent lists reference each other correctly. The reason for that is because the fields all have spaces in them and I do not know how to get a list name with a space in it or to create the proper translation for it. An example of this would be something like what I have written in below ....
View 13 Replies
View Related
Oct 12, 2009
Say in A1 i have either Yes or No, in B1 i have a dropdown validation from a list if A1 is Yes and "n/a" if A1 is no.
I thought if i renamed my list validation to "Yes" and labelled "n/a" as "No", then using =INDIRECT(A1) as my list validation would do the trick.
View 2 Replies
View Related
Dec 31, 2009
I need a formula that can calculate this, but I have no idea how to figure this out since there are so many variables or even what formula this involves:
In cell H25 I need it to sum H21:H24, but if E21:E24 display “Buy” I need it to sum the corresponding value in column E as if it were negative.
View 9 Replies
View Related
Jun 17, 2014
I have a list of departments on "Employee Data" sheet on column A and list of staff names on column B. It looks like this:
DEPT FULL NAME
pdi Bob Tan
pdi John Christian
aftersales_bikes Jim Yeo
I have 24 departments in total and 300 over employees in mt employee data sheet.
On "Jan - June 2014 Training Hours" sheet, when employees attend training courses, I will have to update what courses they went for, no of hours etc.
My problem is:
I would like to select the department (using combo box for the auto complete function) and when department is selected, the staffs in that particular department will show. I have attached the file for your understanding. Currently, I am using data validation with indirect function in that file but would like to switch to combo box.
View 2 Replies
View Related
Mar 20, 2007
I want to create a spreadsheet, where one column allows the user to choose 'P' or 'C' from a list. No problem. I want the next column to contain options specific to what they choose. So if they choose 'C' they get a different list to choose from than if they would have chosen 'P'.
View 11 Replies
View Related
Nov 10, 2009
I would like To display product information in a multi column listbox. Column 1 is a product category and Column 2 is the product description. Now for the dynamic part. I would like to have a combobox loaded with non duplicated values of column 1 of the listbox. When "~Caulking~" is selected from the combobox. The listbox is to display only the "~Caulking~"products and their description. And having a value of "~All Items~" placed into the combobox will display All products in the listbox.
The sheet that will contain the raw data source can/will have items added to inceacing the row count. Also the sheet will be left in an unknown sort by column state. I thought of taking the raw data source and copying it to a new sheet and splitting the data into various columns, Eg 1 column for "~Caulking~" another for "~All Items~"... and then removing the sheet on userfrom completion. Or possably using collections or scripting dictonary or anythink that works well.
View 3 Replies
View Related
Nov 24, 2011
I'm trying to set up a consolidated spreadsheet with a number of tabs and a master sheet to work on. I want to set up this master so that I can type the sheet name into one box and in the next box it will use the sheetname I've just typed in to then pull the array off that sheet. I'm using this with VLOOKUP but when I try and type A1! in in the array section, it doesn't seem to like it.
View 3 Replies
View Related
Dec 7, 2013
I have a spreadsheet that I'm trying to fill with data. There's a lot going on in the sheet, but 1 really useful thing I could incorporate is a running count.
Explanation: I have about 2000 rows of data at the moment.
A row would be finished if it's column J,K,L,M,N & O have data (text) in ALL of them; IE 6 cells of data in order for it to be complete.
So, a running total. If say 200 rows have data in J to O (all 6 cells) the count would show 200. My rows of data start from Row 5. I'd like to add the formula to cell N2.
View 7 Replies
View Related
Jan 28, 2014
In Excel it's possible to create a link dependent of a cell.
Example
='C:UsersAMDesktop[" & C9 & "]Sheet1'!$B$3
where C9=Andrew.xls
View 7 Replies
View Related
Dec 28, 2006
I have been able to use the previous information to create dependent drop down lists but I have been unable to apply the settings to entire columns versus just one cell.
Is there a way to get the dependent lists to correspond to the cell beside it without having to manually type in each cell name?
View 9 Replies
View Related
Aug 12, 2007
I am trying to put together two combo boxes, Combo1 and Combo2, the content of Combo2 will depend on the selection made in Combo1, for example Combo1 will have 10 items, once an item is selected Combo2 will have different sub selections relating to that item. I know you can do this via Validation, but the problem with that I have about 4000 options in the combo1 and about 60000 in the second, here is the structure of my data:
First Option /Second Option
Option1_____1.1
Option1_____ 1.2
Option1_____ 1.3
Option2_____ 2.1
Option2_____ 2.2
Option2_____ 2.3
Option3_____ 3.1
Option3_____ 3.2
Option3_____ 3.3
My ultimate final result should look like this, two drop down menus once Option1 is selected second drop down form should display these options:
Option1 /_____ 1.1
____________ 1.2
____________ 1.3
see attachment for complete clarity
View 9 Replies
View Related
Apr 24, 2008
Is there a way to quickly create a list of all dependent cells?
View 9 Replies
View Related
May 1, 2009
I have to multiply a value X by 20, then depending on the Case = ProteinA or Case Else, round up to the next multiple of 100 or 500.
If Case = ProteinA, I want that 20*x to be rounded up to the next 500.
If Case else, then I want the next multiple of 100.
View 9 Replies
View Related
Dec 3, 2009
I have a spread sheet which tracks work we do on certain items. These items (about 200 of them) consist of a 3 or 4 number tracking code (they are all 4 numbers, but some have leading 0's.) This tracking code is entered into Column B and when we cross reference the number to a chart we have we can determine if item is either, "model A," or, "model B."
I want to get rid of that cross reference chart, or rather, I want excel to cross reference for me and automatically fill A or B into Column C, right next to the tracking code.
Is this possible without VBA? It seems like it may be something simple, but i've poked around and have done nothing but make a mess.
View 9 Replies
View Related
Mar 8, 2009
I created a spreadsheet with a list of cities and attractions in those cities. I want an attraction drop-down menu (cell validation) to be dependent on the city that’s listed in the cell above it. I used the below formula: =INDIRECT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($H$1,"-","_"),", ","__"),". ","__")," ","_"))
This works fine on cities with a dash in them (McGhee-Tyson) or just a normal name (Washington, DC). However, I cannot get the attraction drop-down to work if I select a city with a period (St. Louis, MO) or a space (San Antonio, TX). Am I missing something in the formula? I attached a spreadsheet as an example. I use Excel 2007, but saved the spreadsheet in Excel 97 – 2003 format.
View 2 Replies
View Related
Jul 29, 2006
how to do this and I just can't seem to figure it out...I've come close, but something always seems to be incorrect when I try to do it.
So what I have is 5 column sheet (please see the attached file).
What I would like to do is have the 1st column (Main Folder) be a drop down list and have the other 4 columns dependent on the 1st.
So for example, if I choose Business Hierarchy then in the Subfolder, Subfolder2 there should be nothing shown and under the Attribute column, there should be:
ALL
BUSINESS SEGMENT
REGION
AREA
OPERATING MARKET
COMPANY
MASTER COMMUNITY
COMMUNITY
shown to the user.
Or if I were to pick Unit from the Main Folder, then in Subfolder Unit, Unit Options, Unit Budgets, Dates, etc. should be shown while in Subfolder2 the items for Corresponding to Dates should be shown.
Currently the description box is blank, but will be needed to correspond just with the pertinent main folder selection as well.
Please let me know if you guys have any suggestions, I greatly appreciate. I'm still learning how to do this kind of stuff, so please forgive me again for having trouble with this.
I also understand that if I were to cluster the information in the Attributes column into single cells such as:
ALL
BUSINESS SEGMENT
REGION
AREA
OPERATING MARKET
COMPANY
MASTER COMMUNITY
COMMUNITY
into one cell, then it is very simple, but I do need the seperation between cells due to the description column.
View 9 Replies
View Related
