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?
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".
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.
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.
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?
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.
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.
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.
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:
I have created a sheet and have two drop down menus that allow me to show a picture depending upon the answers from the drop downs. I have used Macros to define what needs to happen on two of the drop downs. Here is where my brain starts to lose it. I would like to create two more drop downs (which I have on already done) that will allow for two more pictures to be shown. Equalling 4 pictures in all.
I am trying to create individualized worksheets based off a master worksheet. I have different committee names that I want to appear on the individualized sheets, based on whether the person is apart of that committee or not. On my master sheet, I choose the persons name under the committee and I want that committee name to show on the individualized sheet. For example, I want A1 on Master to show on Name 1, B3 and A10 on Master to show on Name 1, C3. Can I write a formula to achieve this or or am I asking too much? In my actual file, I will have about 10 names and 5 committees with one person being on up to all 5 of the committees.
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.
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")
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?
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.
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.
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.
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.
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.
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.
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.
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
I have a table (called 'tblFuels' on worksheet"Fuel Data") which contains Fuel Names in column A, I have named the range 'FuelNames', there are several properties for each fuel in columns B to V.
On a separate sheet i have a dropdown box which is populated by 'FuelNames'. When a fuel is selected from this dropdown list, and a button pressed, i would like the corresponding row to be copied and pasted in to a third sheet for use in calculations etc.
The internet has given me several ways of doing something like this and I've given this one a crack, it just doesn't work.
Sub Find_CopyRows()
For i = 4 To Worksheets("Fuel Data").Range("A64000").End(xlUp).Row '("InputFuelSel") is the 'range name' of one cell which contains a dropdown list of all the fuels found in column A
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.
