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


ADVERTISEMENT

Lookup Data For Drop Down List Choice & Show Blank If No Choice

Feb 6, 2008

I currently have a drop down menu in one of my worksheets, in which I have several different text values entered. What I would like to do is link each of those text values to a numerical value, which would be entered in to another cell. So if I select "Option A" from my drop down list, and Option A is equal to 200, I want "200" to show up in another cell. If I select "Option B" from my drop down list, and Option B is equal to 400, I want "400 to show up in that same other cell.

View 4 Replies View Related

Linking A Choice Made In The Listbox To A Variable

Apr 19, 2007

In my interface, I have a listbox with the numbers 1 to 100. In my macro, I need to link the selection made in the listbox (from 1 to 100) to a variable. With that variable I perform simple calculations. Also, do I need to declare a variable for both the selection made in the listbox and the listbox itself?

View 5 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

Texts Automatically Change The Currency Depending On The Choice Made In The Previous Userform

Jul 3, 2008

I have options buttons in a userform, first is "$" the other is "€"

When somebody chooses one of them, it writes the choice to a cell in the data sheet. But when clicked on the next userform I want some of the texts automatically change the currency depending on the choice made in the previous userform.

The formula below was is example

=""&Data!$A$2&" / m³"

=""&Data!$A$2&" / kWh"

View 9 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

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

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

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 View Related

Populate Drop-Down Based On Another Drop-Down Choice

Oct 25, 2006

Here is what I'm trying to do:

I have 4 sheets:
1 called main
1 called states
1 called counties
1 called people

On "main" I have 1 drop down box and 1 cell:

the drop down lists the states from "states" sheet
the cell, which i would like to have as a drop down is supposed to be listing the counties in the state selected from the 1st drop down. right now it is setting the value to TRUE for testing purposes.

then when the county is selected, it will display the people in that county listed in "people". So far I can only get the 1st drop down to list the states. that's the easy part. i need to getting the counties to list in another drop down based on what state is selected.

View 2 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

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

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

Drop Box That Generates A Chosen Table Already Made

Feb 6, 2014

Scenario: I have 5 different tables, all having the same headers. The values under are Vlookups.

Objective: Create a dropbox that lists (Table 1, Table 2, etc.) For whichever table is picked, is the one that will show.

For example, if I want table 1 to populate, I would chose table one in the drop box and so on for the rest of the other tables.

View 6 Replies View Related

Detect When Autofilter Drop-down Selection Made

Oct 6, 2009

Is it possible to detect when a auto-filter selection has been made ? Is that when an autofilter hides rows, the activecell could become hidden, which potentially may cause errant data entry, not knowing what cell is receiving entry as it is hidden from view.

if the worksheet contains a change event that autosizes the target row, it unhides the filtered hidden row in the process. I could say if target is hidden ignore autosize, but i would prefer to activate a visible cell (first visible cell for filtered column) on selection of autofilter.

View 3 Replies View Related

Fill Drop Down Based On Choice From Another

Aug 15, 2008

What I want to do is lets say in the drop down menu I have options Food, sports, Movies. now if I select Sports then it should give me a sub caterory options like baseball, hockey, football and not the options for food & movies as well - so as to make the choices lesser and more user friendly. How do I create that - is it too tough - I am a novice in excel. Can you upload an example sheet with tips on how you did it. I have uploaded an example.

View 3 Replies View Related

Lookup Dynamic Drop Down Choice

Aug 9, 2007

getting a macro to dynamically assign a drop down box to a list of numbers?

Specifically, I have a list of numbers in column A, and I would like to dynamically (because the size of the column differs every time) add drop down boxes in column B so that a user may select different values in column A, simply by changing the drop down box value to "Selected"

This would this make it easier for collect all the "Selected" values and perform further analyses upon them.

View 5 Replies View Related

Drop-Down List To Be Based On Choice Of Another

Apr 23, 2008

I have a drop-down box(K6) When a style is selected I need to have data show up in other drop-down boxes (H3,L3,P3) These selections would only pertain to the selection in K6. They would change when a different style is selected. There are multiple choices in the secondary drop-downs. [IMG][/IMG]

View 9 Replies View Related

Drop Down List Based On Choice From Another

May 1, 2008

What I need to do is create a Drop Down box. When a user makes their selection it gives another drop down box from what they selected. Each choice in the 1st drop down will give a different drop down box in the next field from what they selected in the 1st. I am having troubles getting this to work.

View 3 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







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