Dependent/Linked Drop Downs In Cells

Apr 29, 2008

Now he has another task that I am not having any success with. He has asked if we can make an Excel spreadsheet that allows us to access a list of customer units from a drop down menu which is in another workbook, and once you choose that particular unit, another drop down menu will allow only those customers who are assigned to that unit to be selected from that sub-menu. I hope that makes sense.

Say customer A1 (we will call him Delta Co, 2-1 Aviation) is selected from this first drop down menu (which I haven't figured out how to make yet either). Then this selection would access another worksheet in that other workbook with a new drop down menu with only the four customers in that unit. As an example we will use the names SSG Wilson, SGT Jackson, SFC Jones, and SGT Phillips.

So when the Supply Tech here opens the spreadsheet, the first drop down menu, he will select Delta Co, 2-1 Aviation. Then the next menu will only show four names, and he will select SFC Jones.

Once we get this going, I may be able to figure out the other things the commander wants, if not I will be back.

View 9 Replies


ADVERTISEMENT

Refine Values In Dependent/Linked Drop-Downs

Aug 24, 2009

to make the user experience better by inserting the " Stock Search" sheet to speed up the process. The spreadsheet attached is a simplified version of the current version, where it would normally have many many more sites, areas and models of cars. The existing process means the user has to trawl through the sheet where they are only interested in what sites in their area has stock. I can not change the format of the "Red" and "Yellow" sheets so hoping to insert another sheet to do the work.

I am hoping to have on the "Stock Search" sheet a few drop down boxes.

The user will select

1. Area
2. Type of Colour (the type of colour selected should link with the sheet name in effect, so only stock within the "Red" sheet will be shown if the "Red" colour is selected from the drop down box)
3. Model of Car

This will then give the resulting Store/Stores with stock (value 1 or above) with those conditions met which is showing in the relevant sheet

So as per the attached sheet, if a user selected Area "South West", "Red", "Renault Megane"

then SO10 Clifton 1 and SO15 Yeovil 3 would be shown in a list.

View 5 Replies View Related

Linked Drop Downs Not Populating With Some Characters

Dec 29, 2006

I've created a spreadsheet that has two drop down lists. Based on what the user selects from the first list, the second list is populated. It's working great except for the items in the first list that use special character, such as a -, or &. If necessary I can upload a small example of how I have my sheet set up, but I think I found it on this site!

View 4 Replies View Related

Totaling With Drop-downs

Dec 28, 2006

I have a sheet that has drop-downs with totals affiliated with each option. This is a time recording sheet and I would like for each drop-down type to be totaled accordingly. Any help with an equation would be greatly appreciated.

If you have any suggestions, I can send you the document for review.

View 10 Replies View Related

Simplified Drop Downs

Aug 28, 2008

Is it possible for data like "ABC /sdfsd/sdfs/sdf/sdf/sdf/" to be viewable in a drop down but when selected to appear only as "ABC" in the spreadsheet? I need to be able to see the full line of data when selecting my choice from the drop-down but for readability-sake in a printable spreadsheet only want "ABC" to be displayed.

View 9 Replies View Related

IF Then Statements And Drop Downs?

Aug 14, 2009

can you have col A contain a drop down and then column B include an if then statement that would result in another drop down? IE. Column A has drop down with options of "A", "B", and "C", if the user selects "A", then a drop down would appear in column B containing options "1", "2", and "3". But if the user selects "B" in column A, then a different drop down appears in Column B with options "Yes", "No", and "Maybe"...etc....

View 2 Replies View Related

Drop Downs & Filters

Dec 16, 2008

First post so please excuse me if this has been covered before but I am trying to get the results of a dropdown menu in one worksheet to become the criteria for a filter in another worksheet (both in teh same workbook).

I thought I could just add a reference to the dropdown cell into the autofilter (in VBA editor) but it doe't seem to be that simple.

Any ideas?

View 10 Replies View Related

Multiple Drop Downs

Sep 26, 2007

I'm working with 2 drop down lists created through Validation.

I'm trying to make this scenario work.

If A is entered in B1, then the drop down list in C1 would appear in D1.

If B is entered in B1, then the drop down list in C2 would appear in D1.

List C1 has 12 choices.

List C2 has 8 choices.

I'm making a data entry tab so for the sake of simplicity I only want one list to show up at a time depending on the variable A or B

View 9 Replies View Related

Drop Downs And Adding

Jul 2, 2008

trying to shred the last bits of fat for the summer and thought I'd try a Keto diet, this depends heavily on not eating very many carbs, as well as keeping your total Kcal intake below maintenance.

This makes for a fairly tricky diet, as most things you generally eat contains alot of carbs, so I thought I'd make planning my meals easy, by creating an excel sheet, with drop down menues for different foods/drinks as well as their nutritional content.

I''d like it to look something like this, with the dropdown list under "Food" ....

View 9 Replies View Related

Using Two Or More Drop Downs With VLOOKUP

Mar 21, 2009

I have an analytics sheet where I have a client name chosen from a drop down via validation. The problem I am running into is that while I want information from a data table to populate a cell based on the selection from the validation, I also want the cell to populate based on a second drop down box (basically selecting a time frame). Take the example data table below:

Client Jan 2009 Jan 2009 Target etc etc
Client A 1111 1290
Client B 900 750

I would like the user to be able to select Client B and then, from a separate drop down, also choose, say, Jan 2009 Target and then another cell would populate with, in this case, 750.

View 9 Replies View Related

Dependent Drop Down List With DEPENDENT DEFAULT VALUE

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

Drop Downs Which Would Allow To Choose From A List Of Vendors

May 19, 2009

I have a sheet in a work book which will act as the "Purchase Order" sheet. I would like to have the sheet include a drop down which would allow me to choose from a list of vendors which would print on the purchase order.

View 3 Replies View Related

Changing Drop-downs Depending On Another Cell

Jan 26, 2007

I'm having a difficult time figuring out out to coordinate two cells together.

If a "1" or "2" is entered into cell A1, I would like cell A2 to have a drop down menu show a "0". If a "3" is entered into A1, I would like B1 to have a drop down menu show "1" or "2". If a "4" is entered into A1, I would like B1 to have a drop down menu show "3" or "4". Lastly, if a "5" is entered into A1, I would like B1 to show "5" or "6".

I don't know if this is possible without using VBA.

View 9 Replies View Related

Preventing The Same Choice Being Made In Two Drop-downs

Dec 11, 2008

I am building a template in Excel and I want an error message (or any message) to appear to the user if they select from a static drop-down the same option in column I as in column J (i.e. they have to pick something different in each case).

Issue is I can't exclude any options from the second validation because, essentially, it's the same list. So if, on one row, a person picks "Bill" in column I, they can't pick "Bill" in column J. However, if they have picked "James" in column I, they can pick "Bill" in column J.

Don't know if this is well explained enough but would appreciate any tips on this - I've tried messing about with validation, conditional formatting, putting an IF statement in the next column and so forth but I haven't found a method that isn't convaluted and easy for the user of the template...

View 9 Replies View Related

Force User To Choose From 2 Drop-Downs

Dec 29, 2006

I have two columns, Account Number and Account Type. I already use Data Validation on Account Number to make sure it is numeric and on Account Type to make sure the user picks from a drop-down list. I want it so that if a user inputs an account number, it forces the user to automatically pick from the drop-down menu in the account type column, otherwise post an error.

View 3 Replies View Related

Build A Spreadsheet Containing Data Validation (drop-downs)?

Aug 12, 2014

I am trying to build a spreadsheet containing data validation (drop-downs). So far, so good.

My goal:

* I want to have various cells show dropdowns based on the value of a cell (per row) which itself can be changed by the user using a drop down.

* I want to have the same various cells show dropdowns that are also based on the value of a cell which has a fixed value per column (in other words, a header).

I have tried a lot of different approaches, including using the INDIRECT function, named ranges, dynamic ranges using a table, INDEX and MATCH. All have failed.

The main issues I see have to do with the fact that my data has several possible values for each given header and classification. Also all values are not unique.

The best result I have ever got returned a dropdown list based on the header bot returned the entire column rather than limited to the classification values. So for example I had all instances of 'Main Colour' to choose from, not just those of the classification value.

View 2 Replies View Related

Formatting Area Using Data Validating Drop Downs

Nov 23, 2007

I'm currently developing a calendar that has a list in it with lets say 4 options. What I want the calendar to do is calculate at a specific 'cell' the number of entries that are selected during the month.

The idea is to have a drop down on each 'day' and a counter that calculates the number of times one specific options has been selected. Once the option has been selected the 'day' will change to the corresponding color.

View 14 Replies View Related

Form Buttons, Drop-downs Not Appearing For Some Users

Mar 22, 2007

I have a fantasy baseball spreadsheet I've built. It includes player projections and people can input their league details. It then creates custom player cheatsheets for the user. There are a number of form options including buttons and drop-downs.

I've created this spreadsheet for a few years. For some unknown reason, since I finished version 2.0 of 2007 a few people have emailed me indicating they cannot see the form options. I still see them in my version of Excel. I definitely would have received more emails if this was impacting everyone, so it appears to only hit a few people. I asked about the version of Excel these people have, and that does not seem consistent. Plus, version 1.0 works for them. I only made some formula changes between 1.0 and 2.0.

Has anyone ever seen an issue like this before? Any idea why this might be happening?

The file download is available at the following address (download link on the right):

[url]

There are 2 spreadsheets in the download file. The Compiler is the one with the reported problem.

View 6 Replies View Related

Deleting All Shapes Deletes Data Validation Drop Downs

Jun 1, 2009

I am trying to do here is select a value from a drop down which is linked to a formula which triggers the macro shape..i have all that down already... but the problem is that I will have multiple values in the same drop down and I needed to figure a way to delete the previous macro shape in that range. And so i have created the delete all shapes code below but it seems whenever I use the code it deletes the data validation drop downs

here is what I have so far...

Function Macro()
'
DELETEALLSHAPES
'
'
ActiveSheet.Shapes.AddShape(msoShapeRectangle, 220.5, 105.75, 92.25, 51#). _
Select
End Function

Function CIRCLES()
'
DELETEALLSHAPES
'
'

View 9 Replies View Related

Don't Show Blank Pivot Table Fields In Drop-downs

May 6, 2007

I am creating a pivot table from region, which some of the rows are blank.

Is there any possibility that the pivot table not show the blank in its dropdown combobox?

View 4 Replies View Related

Varying Validation Drop-downs Based On Varying Cell Values

Aug 7, 2013

I am attempting to have cells in Column 'U' deliver different drop-down menus based on the corresponding value in column 'D'. I have created 7 named lists:

List_117G
List_152
List_JMET
List_XBAND
List_PACWIND
List_VORTEX
List_ROVER

Those lists will be called up based on 7 values in column “D”:
“G”
“152”
“J”
“X”
“D/E”
“V”
“R”

So far I have only been able to get this to work for the first category “G”. When I change the value of column “D” from “G” to “152” I no longer get a drop-down. Here is the formula I am using in the List function of validation.

=IF(D6="G",List_117G,IF(D6="152",List_152,IF(D6="J",List_JMET,IF(D6="X",List_XBAND,
IF(D6="D/E",List_PACWIND,IF(D6="V",List_VORTEX,IF(D6="R",List_ROVER,)))))))

View 2 Replies View Related

Drop Down Box Linked To Pivot

Feb 8, 2007

I have a Drop Down / Combo box and when a value is selected I want it to change/update multiple pivot tables.

I am trying to get it to change for one pivot table first and I have the following
Sub DropDown1_Change()
ActiveSheet.PivotTables("PivotTable1").PivotFields("SMS").CurrentPage = [NOT SURE WHAT GOES HERE]
End Sub

I have read somewhere that I can't link directly to the values in a combo box, but I can use the cell link? If so, how do I do that?

View 14 Replies View Related

Drop Down Boxes (linked)

Mar 1, 2007

I would like to have a list of car colours and when clicked a drop down box appears and when the colour is clicked the price appears in another cell - drop down box linked to a price for a particular colour

eg

Colour
Cololur Price

Red 200
Blue 200
Green 250
Black 300
Silver 350

View 9 Replies View Related

Dependent Drop Down Lists ...

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

Cell-dependent Drop-down

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

Dependent Drop Down Forms

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

Validation Drop Down, Dependent Upon Another Cell Value

Apr 21, 2009

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

View 4 Replies View Related

Semi-dependent Drop Down Lists

Jul 30, 2009

I'm trying to make a number of cells dependent to a drop down list. However, these cells would also be drop down lists and while they'd show a value automatically determined depending on the drop down list, the user would still be able to choose another value.

Aluminium
Coated steel
SS304
SS316

This would be my initial drop down list.

In the same sheet, I could choose the materials for the machines shaft, fasteners, anchors, chains, sprockets, nozzles, etc. These materials would be, again:

Aluminium
Coated steel
SS304
SS316

in 90% of the cases, having the machines frame at SS304 would mean the rest of the materials would also be SS304. However, depending on the needs, the anchors could be SS316. So basically I'd like that the options all be in the same material as the frame, but with the possibility of choosing another material through a drop down list.

View 4 Replies View Related

Dependent Drop Down List Keeping Old Value

Apr 11, 2008

My problem is a dependent drop down list that keeps the previous value when a different value is picked in the first drop down list. The dependent drop down needs to change to empty/blank.

The first drop down list is in cell C3.
The dependant drop down list is in cell C4.
The source in C4: =INDIRECT(VLOOKUP(C3,allnames,2,2))

I had a look at various answers on the internet but somehow cannot get it to work (and that is more of a reflection of my own skills than the writers of those answers!).

View 9 Replies View Related

Reset Dependent Drop Down List

May 10, 2007

The only thread I could find on this topic was not resolved. I want to reset the value of a dependent drop down list (in H3) to the first valid choice when F3 is changed.

I have the following code that initially worked but no longer does.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Goto errHandler
Dim DLRng As Range

If Not Intersect(Target, Me.Range("F3")) Is Nothing Then
If Target.Count > 1 Then Exit Sub
Application.EnableEvents = False
Set DLRng = ActiveWorkbook.Names(Target.Value).RefersToRange
Me.Range("H3").Value = DLRng.Offset(0, 0).Value
End If

exitHandler:
Application.EnableEvents = True
Exit Sub

errHandler:
MsgBox "Could not change dependent cell"
Goto exitHandler
End Sub

I now get the error message ""Could not change dependent cell" every time I pick a different item in the drop down list in cell F3. If I remove the error handler I don't get the error and the code simply doesn't work.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved