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


ADVERTISEMENT

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

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

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

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

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

Get Dropdown (gender List) To Affect Data In Another Cell?

Jan 26, 2014

How do I get a drop down (gender list) to affect the data in another cell? ie when male is selected this automatically affects another cell - data 13.5 and when female is selected as gender the cell data is 12.5.

View 3 Replies View Related

Macro To Strikethrough Row Dependent Of Cell Value In Dropdown List

Jul 16, 2008

Is it possible to have a worksheet code that would underline a row if a certain value is selected in a dropdown list?

I have a worksheet with data populated across colums A to K, in Column I there is a dropdown list. What I wanted was to be able to understrike the Columns A to K of a particular row is the value in the dropdown list in Column I ="Cancelled". I cannot use Conditional Formatting as I have already used the maximum 3 formats for other features.

View 9 Replies View Related

Dropdown List Validation - Associate With Same Previous Cell

Jan 8, 2012

I have a workbook with 4 drop down lists. The selection in list 1 determines what is shown in list 2. I wish to have list 3 dependant on list 1 also, but don't know how to associate 2 drop down lists with the same previous cell.

The first list is in cell C2 and the table of data needed for list 3 is AC8:AC27-AO8:AO27,including the column titles.

View 2 Replies View Related

Highlight Given Color On Left Cell Of Dropdown List?

Mar 19, 2012

Column B contains dropdown list with 7 items in it. When an item is selected from the dropdown list I would like to highlight cell in the column A of the same row. Different color needs to be highlighted for every items.

View 1 Replies View Related

Create Dropdown List With A Range From Dependent Cell?

Oct 30, 2013

I have the following table with weeks to display for the holidays and my column H has a drop down list of the first column in the table below with the Named Range, "SNCODE.Season_Codes".

The other two Named Ranges are, "SNCODE.Season_Codes.Start" and "SNCODE.Season_Codes.End"

I need my column K to display a list of weeks from the first week to the last week. For example, the cell in column K for Valentine's Day should have 1, 2, 3, 4.

Basic 1 53
Promotional 1 53
Seasonal Spring 1 13
Seasonal Summer 10 26
Seasonal Fall 23 39
Seasonal Winter 36 53
Valentine's Day 1 4
Halloween 31 40
Christmas 36 48

View 6 Replies View Related

Dropdown List And Return The Emplyee Name To A Cell Using Vlookup

Dec 17, 2009

i have a excel 2003 sheet that needs some vlookup formulas

3 columns in total

employee ID Emplyee name Team

i have worked out how to create a dropdown list and return the emplyee name to a cell using vlookup on the emplyee ID column
I have also worked out how to create a dropdown list and return the employee Id to a cell using vlookup on the employee name column

i really want to return all the members of any team into a single cell but when i create a dropdown list it lists multiple entries for example team1 and only returns a single member to my deignated cell

View 9 Replies View Related

Define List In Workbook States Not A Valid Name

Jan 8, 2009

I have been working on creating a dependent drop down list and have been able to create lists (Insert > Name > Define) and it has worked for all the lists except 2. It will not allow me to create a list titled C or R. I get a pop up stating "that is not a valid name". Why is that?

I have a list for each letter of the alphabet except the letters C & R. No matter what I seem to do I just keep getting the pop up window stating that it is not a valid name. I also tried closing the workbook and restarting the pc and then trying but the same thing keeps happening.Thanks!

View 13 Replies View Related

Excel 2010 :: Resetting Cell Values (Dropdown List)

Jun 23, 2014

I'm using Excel 2010. I have developed a calculator (attached) to make life easier for my colleagues. It works perfectly fine. But one thing keeps bugging me.

In Cell C3 - You have the option to choose "Daily" or "Weekly" (Drop Down). This selection effects your selection for Cell C6.

If you choose Daily in Cell C3 then your options for Cell C6 are restricted to select/enter an amount between £0.00 and £6.00.

If you choose Weekly in Cell C3 then your options for Cell C6 are restricted to select/enter either £0.00 or £12.00.

This works perfect.

However, if I select "Weekly" and then select " £12.00", all my results are perfect which is exactly what I want BUT if I then go back up to C3 and change "Weekly" to "Daily", the £12.00 in C6 remains (though the data validation for "Daily" is restricted to £0.00- £6.00) and all the results are consequently wrong until C6 is changed.

The obvious thing is to delete the £12.00 from Cell C6 or introduce a "clear" button BUT I don't want my colleagues to do this as it leaves the possibility of error and since we are dealing with money, I can't have it.

So what I would love and what would complete this calculator and deem it ready is if every time Cell C3 is selected (i.e. from the drop down list you choose Weekly or Daily) it as a result resets Cell C6 to £0.00.

Calculator 23-06-14.xlsx

View 6 Replies View Related

Autofilter Data Based On Cell Value (dropdown List) In Different Worksheet?

Apr 5, 2013

I've created drop-down lists in cells B3 and B4 (this is in worksheet 1), based on a column in Worksheet 2. I'd like Worksheet 2 to autofilter the data based on the drop-downs in B3 or B4, or both together.

View 2 Replies View Related

Excel 2007 :: Populate Another Cell Based On Selection In Dropdown List

Mar 7, 2013

[URL]....When I select a name in column B, it populates column C's dropdown with that name's list of units. When I select a unity type in column C, I'd like it to automatically populate column E in the same row with the value associated with that unit. The values associated with a particular unit can be found to the right of the sheet. So if in row 2 I select Blake in column B, then Unit 5 in column C, I'd like column E to be populated with 14.

Edit: using Excel 2007.

I attached stripped down version of the sheet which is small enough to post. None of the things I removed should affect the topic at hand. The full sheet is available at rapidshare.

View 6 Replies View Related







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