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
how to create drop down lists which is making a sales forecast template for my small company look pretty jazzy. Of course, now I want more out of it and can't figure it out.
I successfully added a drop down list for a sales person to pick a supplier, let's say their selection populates cell E4. Once selected, the next cell over (F4) gives them another drop down list with the products made by that particular supplier. The next cell over (G4) is in a column titled "Unit Cost", how can I make the Unit Cost cell populate automatically when the product selection is made in F4?
NOTE: My "lists" are on Sheet 1 along with my working spreadsheet. I have a Suppliers List, Products List (for each supplier), and anticipate I will need a Price List for each Product List, right?
Once I finish the spreadsheet can I cut and paste all the data to sheet 2 (I put it 100 rows below my spreadsheet to hide it)?
I've created a drop down box which displays a list of headings for columns. The user enters the total for that heading in that column and then a total column sums all the entries for that row. However, I wanted to simplify it so that the user just enters the total and then selects the column heading from a drop down list and then the value entered in the total column is automatically entered into the column corresponding to that heading in the drop down box as well. I've attached a jpg which should give you an idea of what I'm talking about.
The values in column E are the ones the user enters, I then want these values to be put into the corresponding row based on what they select in the drop down box in column F
I just want a simple autofill to keep from honking up my ST hours/OT hours... if you enter 6 days with a simple cell*cell formula you can get 48 hours ST and that just won't do...
How do I formulate so that when I enter in the days it automatically fills in the list hours I have for reference?
Days - ST - OT
1 8 4
2 16 8
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
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 RelatedI 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 Relatedexample.png
I am sure this is simple and easy to do, but i am having difficulties achieving this.
I want the cell to fill as it gets closer to 100%, I am sure its conditional formatting but I cant seem to get it to work.
I'm trying to record a macro that is using vlookups to get data from another data sheet, this data sheet will update each month - the old data moving back a column (so the new data is filled into the same column each time).
However, on the sheet where i am recording the macro, i need the data to fill in the next column each time.
I have recorded the below:
Sub Colourants()
'
' Colourants Macro
'
'
ActiveWindow.SmallScroll Down:=-30
Range("AK3").Select
[Code] .......
How do I get it so it doesn't record in cell 'AK' all the time but the next empty column each time it's run (however, it will always run from row 3).
In column "L" there is the possibility to have one of the following characters entered as a key for that specific row;
G
X
B
G1
G2
S
Y
H
SB1
SB2
They all have a unique color assigned to them. There are too many for conditional formatting, so I think the way to resolve this is to use VBA. Can I ask for some assistance to get me started?
How do I add a drop down list to a cell?
View 3 Replies View RelatedI 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 RelatedWhat 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 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 RelatedI 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 RelatedI 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).
Is there a way using a macro to determine which cells have a dropdown list and then retrieve the name?
View 4 Replies View RelatedIs 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 RelatedI 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 RelatedI 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 RelatedI want to select Work Type and it will then look at the list data and auto fill the highlight cells.
View 5 Replies View RelatedI 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].....
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 RelatedI 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] .....
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.
View 3 Replies View RelatedIs 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.
View 1 Replies View Related