Fill Table Using Drop Down List Data Selections
Jul 10, 2009
I have a couple of drop down lists of data created from lists as well as fields next to it.
What I want it to do is take that data, which is name, start time, end time, days worked, queue (or work type), and fill the table next to it which is just a 30 minute by 30 minute schedule sheet with days of week 1 and week 2 on top.
I figure it would be easier to have a GO button to do this.
I will attach an example of what I mean, but please, if you guys find that there is an easier way to do this, just let me know, I feel this might involve some code/macros instead of excel functions
View 2 Replies
ADVERTISEMENT
Dec 19, 2007
I have a list of 688 codes in a column (lets say column A). e,g 23, AB, FX, NV, D8. Each code corresponds to a text In the next column (lets say column B) for example AA is the code for "Transmission". Using a clean spreadsheet and using a drop down list, I would like the cell to the right of the selected dropdown code, to automatically fill in the text of what the code corresponds to.
View 5 Replies
View Related
May 6, 2009
I want to put a drop down list in Cell D3 with the list of names from column B. There are 14 different names, but when i try and create the list it gives everyname from Column B.
Also once the drop down list works i would like the table to be populated with the managers supplier, so if Dan was chosen in D5, Suppliers 1 to 9 would appear below D3.
View 7 Replies
View Related
Aug 19, 2014
I'm creating a new spreadsheet for different fines we have as a football club.
I have a table frozen at the top which looks like this:
Fine 1 Fine 2 Fine 3
Player 1
Player 2
Player 3
Then also I have a list below this with the date and specific fines:
Date Player Fine Amount
(drop down (drop down Entered manually
list of players) list of fines)
I am wanting the amount of the fine to be entered into the table at the top of the spreadsheet automatically based on the 2 drop down list entries. I would also need the table to keep adding the fines together once new entries are made.
View 1 Replies
View Related
Nov 8, 2009
is there a way to take a drop down list and pick 1 then have excel fill in the info i seven cell example if list box is 3 then cell 1-7 = 1 and is list box is 1 cell 1=1 cell 2-0 cell 3 = 0 cell 4-7 = 1
View 9 Replies
View Related
May 9, 2009
I'm working on making a spreadsheet that allows me to select an item type from a dropdown list (through validation) and then would copy in a range of values from another worksheet based on my dropdown selection.
The set-up: I am primarily concerned with two sheets in my workbook, BiS and Weights. I have a database of items and their associated values listed in Weights. I have already managed to get dropdown lists of my specific item types using named lists and have put that in the BiS worksheet.
What I would like to do is have the values in the Weights worksheet copied over in the same order and number of cells based on what item I select from the dropdown list.
View 6 Replies
View Related
Sep 22, 2008
I am trying to make a calendar spreadsheet to enable me to track allowance payments i am due from my company.
This payment is worked out by three conditions - where i am working (7 regions), how many days of the week (4,5,6 or7) and how many hours (<7,8-9 or 10-12)
I have made drop down lists to select each of the values for the three conditions and want to show the total for them
i can total the entire spreadheet for the month up using fairly large "COUNTIF" statements, but i want to be able to show what the exact amount is in each cell not just a complete total.
i.e. i am away for 6 days i get £15 extra, if i am in Europe i get another £50 and if i work 12 hours i get £30.
I want to be able to calculate this total in each cell for that day.
I can send a copy of the spreadsheet i have got at the moment if that will make things clearer than what i have tried to explain.
View 12 Replies
View Related
Nov 15, 2008
I am kind of new to Excel programming and would like to know if there is a solution to my problem. What I need is to have a dropdown list (I know how to make this) then select an item from the drop down, then based on the name i select, Excel automatically fill up the rest of the cells.
For example, from the drop down list I select the company name then Excel automatically type the address, phone number, Fax number and the contact name of the company for me in corresponding cells. Is there a way to do this?
View 3 Replies
View Related
Nov 28, 2012
I would like to find out how can I create a chart, where it is interacting with the selection of 3 drop down list (created from data validation-list option). It will show up to 12 months of data.
First list would have only Male & Female, 2nd list would have 1st Class, 2nd Upper, 2nd Lower, 3rd Class and Pass Only, 3rd list would have all the months of 3 years.
My data is from J9:U22. These data needs to be changed accordingly, reading from D45:U58.
For the graph, if I select Male, 2nd Upper, and Jun-2012, I want it to show only this selection, where the period will be from Jul-2011 till Jun-2012.
Previously I have done one, with only 1 selection of drop down list, where I used Vlookup. Now involves 3 criterias.
Or is there an easier way to do it?
View 3 Replies
View Related
Jul 18, 2009
I have zero understanding of how to do VB. I am trying to create a risk assessment template where I have a ton of questions to which I want a column E impact drop-down selection of N/A, High, Medium, Low; a column F probability rating of the same. This SHOULD a result in the subsequent two columns result based on those selections.
For example, Column E selected as High and Column F selected as High should make Column G automatically display High and, ultimately, column H to display 100.
Here is where I am at for trying to get Column G's result though all I seem to be getting is a FALSE response to each state instead of the intended result.
=CONCATENATE(IF(E11="High"&F11="High","High"),IF(E11="High"&F11="Medium","Medium"),IF(E11="High"&F11="Low","Low"),IF(E11="Medium"&F11="High","Medium"),IF(E11="Medium"&F11="Medium","Medium"),IF(E11="Medium"&F11="Low","Low"),IF(E11="Low"&F11="High","Low"),IF(E11="Low"&F11="Medium","Low"),IF(E11="Low"&F11="Low","Low"),IF(E11="N/A"&F11="High","N/A"),IF(E11="N/A"&F11="Medium","N/A"),IF(E11="N/A"&F11="Low","N/A"),IF(E11="High"&F11="N/A","N/A"),IF(E11="Medium"&F11="N/A","N/A"),IF(E11="Low"&F11="N/A","N/A"),IF(E11="N/A"&F11="N/A","N/A"))
View 3 Replies
View Related
May 26, 2007
In the attached spreadsheet NamesReference.xls, cell A1 of Initial Quality worksheet has a drop down that apparently references the Namelist? "FieldeList" which is on the List worksheet, cells A1-A14. I understand how to set up the FieldeList Nameslist, but by examining cell A1 of the Initial Quality worksheet, how can you determine that this reference exists, or how do you establish such references to Namelists, with the drop-down arrows?
View 2 Replies
View Related
May 7, 2014
I've written a procedure that loads a list of country selections in a dropdown (see attached/vb editor/ThisWorkbook).
The problem is the valid values for this column need to be just the two digit country codes, not the country code +dash+country name. The reason the dropdown selections include both the two digit country code and the country name is because most users will not know the two digit codes. Presenting the selections in this fashion will make t much easier for the user to make the proper selection.
So here is what I need: When the user makes a selection from the dropdown list, the resulting value needs to be the two digit country code only. Is there a way to incorporate this formula .... =MID(B2|1|2) ... in the vba procedure which runs after the user makes a selection? Or, is there another way to accomplish this?
Example_COO.xlsm‎
View 10 Replies
View Related
Mar 19, 2009
I'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.
View 2 Replies
View Related
Feb 27, 2009
I have set up a file with drop down selections from column B to R copied down to row 3000. I am sure this is why the file is slow when you make a selection. How does one speed this up?? Is it possible?? I created it using Excel 2007 saved as a 2003 version.
View 3 Replies
View Related
Dec 28, 2007
I have three lists in the first sheet 'Food', 'Quantity', 'Points Value'
Each food (i.e. tuna, pasta, anchovies) has a quantity (i.e. 40g) and a points value (i.e. '50'). The first list ('Food') has been copied as a drop down list in the second sheet. When selecting a food, I would like the cells 'quantity' and 'points value' to pre-fill - taking the data from the first sheet.
i.e. if say Anchovies has the quantity value '30g' and Points Value '2' on the first sheet, then in the second sheet if anchovies was selected from the drop-down menu, these values would add themselves. how to do this? I have attached a sample file shwoing what I want to do.
View 2 Replies
View Related
Oct 26, 2009
I need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .
View 4 Replies
View Related
Dec 22, 2008
Is it possible to have the value in one cell determine which cells to "data validate" for a drop down list?
Example - I have three different Ports of Entry with different arrival dates.
When the user inputs the Port of Entry into a cell can I create a drop down list that shows the data related to that individual port?
View 10 Replies
View Related
Oct 10, 2013
I was wondering if there is a way to see all the choices on a drop list. Currently the drop list only shows 8 choices but I am wanting to see all 32 choices eliminating the need to scroll the list. I have attached a picture.
View 4 Replies
View Related
Sep 16, 2006
i have a pivot table that shows the customer names. when i select the customer drop down box i can all the customer i want to see. but in the table itself there are some customer not showing. this is the first time this has happened
View 9 Replies
View Related
Dec 9, 2009
I have a drop down box in column N, however I would like the options in that drop down box to change depending on what appears in column M.
If column M Says "Lapse" then I want one drop down box to appear in column N, If coumn M says "NTU" then I would like column N to show different drop down options.
View 12 Replies
View Related
Dec 11, 2006
for some reason my data validation drop down lists have dissapeared. The relevent cells indicate that the data validation has been set-up, but the drop down list is not available for some reason.
View 9 Replies
View Related
May 3, 2006
data validation drop down list find
i have a data validation drop list of week starting dates. the list works great, but
i have to scroll through more and more as the year goes on...
?can we have a letter sensitive find (as in an access combobox)...?
View 6 Replies
View Related
Sep 2, 2006
I am using a Pivot Table to sort, combine, and sum data. After this is complete I want to copy the pivot table and paste it (values only) to another worksheet and use the data again. The problem is the pivot table does not fill in all the blanks and leaves empty rows. The there a way to force the pivot table to fill in the labels?
View 6 Replies
View Related
Feb 4, 2014
I am trying to create a drop down list so that when the user choose Option A, Outcome A populates the cell.
So for example, I am looking to show a list of all Grades within the company, when the user selects a grade, the salary is populated into the cell.
View 7 Replies
View Related
Nov 14, 2008
i have been looking around here and it seems like my problem is similar to many's regarding the vlookup function. to me, what i'm trying to do sounds simple enough, but it can't get it to work. i have a table that has three columns, Item Number, Item Description, and Amount.
Each item has it's own number, a corresponding item description, and ammount (obviously), but there are some repeats. What I want to do it input the Item Description, and have one field automatically pull up the Item number, and the next field, pull up the price. I am using a drop-down list for the Item Descriptions utilizing data validation. here is formula that i have been trying to use that is not working: =VLOOKUP(B2,Sheet1!$A$2:$C$18,1,FALSE). i have attached a trial worksheet that i am using to work things out on.
View 5 Replies
View Related
May 11, 2009
I have a spreadsheet called contacts which is as it says, I have another sheet called project management, I want to have a drop down list which refers back to the contacts spreadsheet, it this possible as they are two different files?
View 4 Replies
View Related
Jun 5, 2006
I have not found a way to control the width of a validation drop down menu. I have 3 drop down list. Two of them are in wide column cells and one a narrow column cell. For some reason my narrow column cell gives me a wide pull down even though the length of the data in this field is only 3 to four characters.
View 2 Replies
View Related
Oct 4, 2006
I'm trying to do is build a form that will allow me to select from a list of options, that links back to a catologue of data so that when i click on the generate button it will pull the data associated to the item selected from the list into a text box in excel. I have attached the form that I have created.
View 4 Replies
View Related
Nov 21, 2006
I have noticed that all the cell dropdown lists i have (created by using Data | Validation | Allow | List) are very difficult to read its as though the font is size 8 or 6 or even less, is there a way of displaying the dropdown contents in a larger format? i have tried changing the font size of the named range and of the cell holding the dropdown but to no avail.
View 4 Replies
View Related
Jan 7, 2008
I have a workbook with 7 sheets, the drop down list operates correctly on all but one sheet, it used to work on all sheets. The arrow on the right of the selected cell dose not appear onthis particulr sheet. I have rebooted the PC and double checked the in-cell option. I have search the forum for similar problem and found the same problem but no remedy.
View 2 Replies
View Related
