Use Or Not Use Dropdown List Depending On Another Cell Value?

Aug 18, 2014

I would like to use or not use a dropdown list in data validation depending on the value of another cell. The application is to be able to choose a state from the dropdown list only if the country selected in another cell is "US". If the country is not US then I want the user to be able to fill in free text and there be no dropdown list. I know it's possible to have a dropdown list and allow entries without it being on the list but I need the dropdown list not to appear at all if the value is not US.

View 7 Replies


ADVERTISEMENT

Single Cell Value From Either Dropdown List Or Enter Manually Depending On Selection

Jun 22, 2014

I have a cell in my spreadsheet that I use to control the size of a column. I formatted the cell as a number and added data validation to make sure the number is greater than zero. Then I realized that I need to also allow for the option of auto sizing the column as well. This would require a data validation list type with something like True and False for the choices.

What I want to be able to do is have it both ways. I want a drop down list in that cell with the options Auto Size or Custom. If Auto Size is selected the cell value gets set to that. If Custom is selected I then want to be able to type in a number.

ddl.png

[URL]

Is there a way to setup a cell such that the value is either an item from the drop down list or, entered directly (depending on the list selection)?

I know I can do it with dependent lists but that would require two cells, one for the auto size mode (true/false) and the other for manual width value.

View 1 Replies View Related

Assigning Certain Cell Ranges Depending On What Is Chosen In Dropdown List Of 20 Things

Jul 16, 2009

I see that IF statements can only be nested 7 times. How do I create a cell that checks to see what item was selected in the dropdown box of 20 different choices and choose a particular cell range depending on what is chosen?

View 9 Replies View Related

Dropdown List Depending On Previous Values?

Jan 3, 2013

see attached document - this is a stock record sheet. what i want it to do is when Bed is seleceted in column B - i want colum C to show the BedSize list which is in the lists tab. and the same with Chair i want it show ChairSize

View 14 Replies View Related

Auto-Populate Data Depending On Selection From Dropdown List

Jan 21, 2013

How to populate MTD data linked to the other spreadsheet file (monthly data) to the table on the left, depending on the month selected month from the dropdown list.

Attached files for reference :
Dropdown Month.xlsx‎
MONTHLY DATA.xlsx

View 3 Replies View Related

Cell Value Is Dropdown List Based On Other Cell Value Which Is Also Dropdown List?

Aug 4, 2013

fill the column "Level 2 Area" based on the value selected from "Level 1 Area" which is coming from a drop down list. So the "Level 2 Area" will be a drop down list also based on the selected value from the drop down list from "Level 1 Area".

Level 1 Area
Level 2 Area

View 7 Replies View Related

Dropdown List From Comma Delimited List In Single Cell

May 9, 2014

Is there a way to create a drop down list from a comma delimited list in a single cell? For example, col A is Name & Col B is the delimited list - Blue,Red,Green (list can be different for each name). Would like a drop down list in col C that allows you to pick one of the values from Col B.

View 3 Replies View Related

Entering List Depending On A Cell Value?

Feb 6, 2014

i have 5 lists of names which i want the sheet to enter depending on the cell value of C1. C1 is a drop down of 5 different departments so when C1=department 1 for instance i want A4:A25 to automatically update the list of names that i have against that department.

im sure its fairly simply but i just cant get any formula i use to work!

View 6 Replies View Related

Dropdown List Based On List In Another Cell Using Indirect?

Jan 29, 2013

I have 3 related dropdown lists that work perfectly, if you enter data from left to right. But, if you click in the cell containing the second list, which is based on the first list, of which nothing has been selected, you can just type any value in the cell. Is there a way to prevent this, or at least validate that what is entered is a value in the list.

View 5 Replies View Related

How To Highlight Row Depending On Chosen Dropdown Value

Jun 25, 2013

I'm looking to use a drop-down to allow me to highlight a complete row depending on what I choose, each row is unique.

So if my drop-down is say 20 different words and I choose "Oil" I want it to look down the table and highlight the row that shows oil prices.

Example of column A might be as shown below (Starting in say A3).

(A3)Petrol
(A4)Wood
(A5)Oil
(A6)F/Fuel
(A7)Other

From my drop-down located in A1 I choose "Oil" I want it to select only row A5 and either highlight it or blank out the rest.

View 7 Replies View Related

How To Make Few Dropdown Lists Depending On One Before

Jan 7, 2014

how to make few dropdown lists depending on one before.

Example: I have table with next data: COLUMN A: (A1) Expense Type ( in all columns under A1 are types of expenses );

(A2) total trip cost;
(A3) Prize promo tour cost;
(A4 ) court renting cost;
(A5) Prize IPP cost

In columns B1, C1, D1, E1 are cities. Under each city is value for type of expense. I have uploaded worksheet for example.

Now, problem is next: I am trying to make drop down lists ( in new work sheet ) by using depending data from data table.

1.I made drop down list in first cell (let's say it is an A1 cell ) where I can chose city ( for example City of Zagreb ).

2.Then in next cell (B2) I would like to choose type of expense in drop down list ( for example Total trip cost ).

3.Finally, in C3 cell I would like to make drop down list that offers me just expense value for combination of chosen city ( Zagreb ) and chosen expense type ( Total trip cost ).

View 5 Replies View Related

Add Dropdown List To A Cell?

Mar 7, 2012

How do I add a drop down list to a cell?

View 3 Replies View Related

Dropdown List For Cell

Oct 18, 2007

I inherited the attached spreadsheet and cannot figure out how to change the dropdown control and the tool tips? If you click in either of the top two yellow cells a form control dropdown appears...I can't seem to get to the properties of the dropdown? Also, when clicking in each yellow cell...a tool tip like pop-up appears. Those I cannot find a way to edit either? I can't find any code for any of this...and they all act the same when I disable macros?

View 2 Replies View Related

Applying Certain Formulas Depending On Dropdown Selection

Dec 6, 2013

Any way to apply a formula to a cell depending on what choice is made from a drop down box in a cell that it refers to.

Hypothetically:

I have a drop down box in A1 with 2 options: Cookie Making Costs - or - Cake Making Costs
In cells A3 through A10, I have cells with the costs for all the ingredients (and B3 through B10 for cake ingredients).
If I select Cookie Making Costs, I would like B1 to apply a formula that sums up all the costs associated with making cookies "=sum(A3:A10)"
If I select Cake Making Costs, I would like B1 to apply the sum of the cake ingredients "=sum(B3:B10)"

View 2 Replies View Related

3 Different Tables - VLookup Depending On Selection From Dropdown

Jun 12, 2013

I have 3 different tables on a sheet which I want to do a vlookup on depending on the selection from a dropdown.

I created the ranges I want to use in 3 cells and tried to reference the cell rather than the range. Excel no likey:

=vlookup(B2,A1,2,FALSE) instead of =VLOOKUP(B2,D1:H14,2,FALSE)

Is there anyway I can do what I am trying to do?

View 2 Replies View Related

Changing Formats Depending On Data From Dropdown Box?

Sep 4, 2013

I have a table showing data for 10 teams. There are however 10 different measures which are pulled from a seperate sheet using a dropdown box to select the measure.

One of the measures is example 390823 which needs to be format 390,823 so that thousands are shown, and other formats are, example, 89.9 which need to be 89.9%.

Ive gone to my other sheet and all the raw data is showing correctly with % and ,s. But my dashboard table can only have one format. How do i make it so that each measure pulls in the correct format when selected, without dragging the whole area and changing each time?

View 1 Replies View Related

Cell Reference From Dropdown List

Aug 25, 2014

What is the formula in excel where the cell in reference return a value from a drop down list?

For example: I have a drop down list of HomeLoan Programs with rates from 3 different channels. If I choose a 30yr FNMA with rates 3.875 = 100.125 ; 4.00 101.250; 4.125 = 102.00

If I choose 20yr FNMA it will return the pricing to the cell next to the program.

I provide a spreadsheet.

30yr FNMA works from the drop down but all other programs does not work. I am not sure if I have to reference and index or match.

View 2 Replies View Related

Dropdown List To Define Name Of Cell Not Value?

Jul 6, 2014

I'm trying to create a drop down list that will define the name of the cell so I can reference it in formulas or codings to change the format of various cells defined by a specific name.

I'm not even sure if I can have multiple cells defined as the same name

I'll be inputting data into cells, and I want the color of the cell to change depending if the data is one of these criteria: 'In Service', 'In Transit', or 'Must Purchase'. I can't just make separate criteria columns to list all the data, because the data is already placed in a specific order. So I want whoever is viewing this to know which entry fits which criteria from the color of the cell.

The only thing I could think of is inputting the cell data value, and a drop down menu to define the cell name. I'll input a conditional formatting function to format based on the defined name criteria.

View 14 Replies View Related

Dropdown List And Separate Value In Same Cell?

Jan 3, 2013

I was wondering if there is a way to have a single cell display a value and a drop down list that shows the chosen value. For example, I want to be able to enter into a single cell "365" and select "Hours" from a drop down list and have both be displayed in the same cell. I want to do this because I like to be able to sort my spreadsheet and I have a lot of information that spans across the row that I want to keep tied together. Is this even possible?

View 2 Replies View Related

Dropdown List Fills In Other Cell?

Mar 12, 2012

I am creating a spreadsheet questionnaire and I have a cell where a selection is made and based on that selection, I want it to populate another cell with a different list of information. In simple form:

Drop down picks a name: Bob

Quote number (when bob is selected): 34xxx

View 4 Replies View Related

Dropdown List With More Information Than In Cell

Dec 28, 2012

I am trying to create a drop down list that shows the description of different codes. i.e.

1000 - Straight time
1010 - Vacation Time
1020 - Sick Time; etc.

In the spreadsheet, I only want the number to show (1000, 1010, or 1020).

View 2 Replies View Related

Determine If Cell Has Dropdown List

Apr 5, 2013

Is there a way using a macro to determine which cells have a dropdown list and then retrieve the name?

View 4 Replies View Related

In-cell Dropdown List To Select Value From

Dec 19, 2013

Is it possible to have an in-cell drop down list to select a value from, while still being able to enter free text?

View 2 Replies View Related

Dropdown List To Navigate To Certain Cell?

Jun 18, 2014

I want to produce a drop down list of values and when you click on the different options it takes you to a cell corresponding to the option selected.

View 9 Replies View Related

Populating Cell With Exact Value From Dropdown List?

Mar 28, 2014

I am using the form control data validation drop down list with 9 entries in the list. How can I get the entry that is selected in the drop down list to populate exactly into another cell on a separte worksheet? I have linked the drop down list to the cell, but the value is populating as a number rather than the text entry that is in the drop down.

View 7 Replies View Related

Dropdown Menu From A List That Autofills Another Cell?

Aug 13, 2013

I want to select Work Type and it will then look at the list data and auto fill the highlight cells.

View 5 Replies View Related

Changing Value Of Cell By Change Of Value In Another Cell Using Dropdown List

Jun 7, 2013

I have a spreadsheet with numerical data in B1:B11 and textual data in C1:C11. The numerical data is a couple of digits, nothing big, and the textual data is always two letters, in this case AB, AC or AD. I have the options for AB, AC or AD for each of the cells in C1:C11 in a data validation drop down list. What I'm trying to do is make a VBA macro, of some sort, that acts upon when, AB for instance, is changed to AC, and then multiply the adjacent numerical value in the B column by a conversion value:

AB -> AC = 3
AC -> AD = 7
AD -> AB = 4

So for example, if I had cell B2 as 10 and C2 as AB, then changed AB to AC using the drop down menu, the macro would recognise the change, select the adjacent cell, B2, and multiply it by 3 to get 30, and put 30 in B2.

This is what I've got so far, and I'm no VBA expert, so I've probably made mistakes in multiple places. At the moment, the code below is getting stuck on active.celloffset - and I'm really not sure why. I did manage to get it working with specific cells rather than a range, but that only ever worked once and I had to close and re-open excel to get it to work again. Is my code any good, or am I coming at this from the wrong direction?

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Code:
Static ov As Variant
For Each Cell In Range("B1:B10")

[Code].....

View 9 Replies View Related

Dropdown List Range Based On Two Different Cell Values

Aug 2, 2012

I'm new to excel and was trying to make a workbook that will have a drop down list populate based on a user input in two separate cells. Basically, i have columns: name, pages, and books. I would like to have the drop down list match data by first finding the amount of books read, then finding the amount of pages read. Then any name that meets the criteria will be available in the drop down list. How can I do this?

View 1 Replies View Related

Dropdown List (DV) Doesn't Work Same As Typing In Cell

Aug 26, 2013

I have written code in which cell color changes according to cell value. To change cell value I have used drop down list (Data/Validation/List). Main question/problem is code works well when cell value is changed by typing from keyboard only.

Code doesn't work when cell value is changed using drop down list.

Attached is the test file : Test_26082013.xls

Also refer link [URL] .....

View 1 Replies View Related

Comments From Dropdown List - Delete If Cell Value Deleted

Sep 11, 2013

I created comments to be shown when drop down list items are selected using the helper cell and workbook change solution from Leith Ross at the thread below.

[URL]....

This works perfectly to show the comments. What I'd now like to do is delete the comment if the content of the cell is deleted.

View 5 Replies View Related







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