List Data Selection
Jul 31, 2009
I have a list set up with a bunch of different locations and I want to break them down into their regions.
So I created my list of regions, but what I want to see is if I can limit the number of locations to select from after the region is selected. If the region is not selected, than a location can not be selected yet.
For example use, my drop down list for Region is in A1 and my drop down list for Location is in A2. The Region variables are in D1:D8 and my Location variables are in E1:E32.
Also, if the region is not selected, than a location can not be selected yet.
View 9 Replies
ADVERTISEMENT
Jun 24, 2009
I am trying to create a drop down list that when selected will display data in the 10 rows below and 4 columns, so a total of 40 cells. I would like the data to be based on the selection in the drop down list.
The data looks like this,
RequirementsQtyResourcesQty
Level 1 Sentinel10Level 1 Sentinel105
Level 2 Sentinel10Level 2 Sentinel167
Level 3 Sentinel10Level 3 Sentinel156
Level 1 Banga20Level 1 Banga401
Level 2 Banga20Level 2 Banga307
Level 4 Banga20Level 4 Banga0
i have 27 different combinations of the above list with up to 10 different rows. I have a label for each one, but i cannot get the rows below my drop down list to display the proper values base don the selection in the drop down list.
View 8 Replies
View Related
May 28, 2014
I want to load the actual data exist in the rows by selection value from the data validation list.
E.g I have two worksheet in one excel file. One has a data activities of persons with their name like two columns i have in which one exist the name of person and second exist the activities which they perform.
On the second sheet, i made a data validation list of all the person names
Now my requirement is, when i select a person name from the list, load all the data from the 1st sheet to second sheet. Is this possible without VB code, because I want to share it on the Google sheet with my boss, where VB sheet is not supposed to work.
View 13 Replies
View Related
Nov 15, 2011
I have a large set of data that I need to use for data validation in drop down lists. The data is arranged in 4 columns and entries within each column may repeat numerous times. The four columns are as this..
Category Subcategory 1 Subcategory2 Subcategory3
The first data validation will come from the first column. Once this is chosen the second drop down should populate with the subcategory that correspond to that category stored in column 2. once that is chosen the thrid data validation should populate with the corresponding subcategory from column three etc.. This is a small sample of the data in the columns.
View 5 Replies
View Related
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
Jun 30, 2014
I have created a Data Validation list in one of my spreadsheets which works fine. The list itself has no duplicates which is fine but when I select my entries in the other spreadsheet, I want to make sure they cannot select the same value twice.
I tried selecting "List" in data validation and using an AND with COUNTIF but it doesn't work.
=AND(Employees, countif($A$1:$A$20,A1)=1)
View 2 Replies
View Related
Dec 13, 2009
I'm using Excel 2007. I would like to seek some advise on how i may update cells after selecting a month from a drop down list.
i have created a simplified version of what i intend to have. One the 1st tab 'Cash Budget 2009', i have filled up a table with numbers, sorted by months. On the 2nd tab 'Dec09', i would like to create an expense table, to be able to be selected by month. So i have created a drop down list based on the months that are created in the 1st tab.
Upon selection of the month from the drop down list, i would like the cells to display (fetch) the data from the 1st worksheet. It would also be helpful if the name of the 2nd tab can be updated to read as the month that is being selected.
View 4 Replies
View Related
Dec 26, 2012
I've created seven names in my data validation source list on Sheet 3 in the following range of cells, A2-A7. My data drop down validation list is located on Sheet 1, A2 in the same workbook. I would like to trigger a macro based on the name I select in this drop validation drop down list that will fill out an address, telephone number, and email address in the following cells next to my data validation drop down list on Sheet 1: B2, B3, and B4. I want it to be designed so that users will select a name and have that person's corresponding address, telephone number, and email address fill right next to their name on the same sheet.
View 6 Replies
View Related
Jan 13, 2009
I am trying to create a fairly simple spreadsheet with about 8 columns and about 400 rows. One of the columns features a drop-down list with about 8 or 9 different options. Dependant on which option is selected, i would like the entire row to change colour with that option.
For example:
FAILED - whole row changes red
SUCCESSFUL - row has no fill
Tested - row changes to orange
etc.
Is this possible within Excel 2003?
View 9 Replies
View Related
Jul 31, 2009
I have an excel workbook with two sheets. Sheet 1 has a list of people names, rank, address, and phone numbers. Sheet 2 has boxes where a user can select a last name from all last names in sheet1. What I want to happen after the user selects the last name in sheet 2 is for it to automatically fill in the rest of the data (ie Rank, First Name, Address, city, Home phone number, Cell Phone number). What do I need to do in order for this to work?. Attached is a very small example of my much larger project.
View 3 Replies
View Related
Jul 17, 2009
I have a list of 4 customers and their individual revenue, which is summed up in cell E12.
What needs to be done to make Excel only sum revenue of say customer A and D in cell 12 upon selection of these through standard filter (see attached sample)?
View 2 Replies
View Related
Dec 11, 2012
Regarding the below code:
VB:
Sub AutoPopulate()
Dim i As Long
Dim lr As Long
Application.ScreenUpdating = False
[Code] ....
This code relates to a list I have determined on my excel spreadsheet using a range from another sheet in my spreadsheet.
Basically this is a standard group of domains I want people to use, but based on where the user will use this there may be local variations for example amount, some people here use UKDW amount at 15, 2.
As this is a global project the above is the global standard I have set out. What i want to do is if people in the UK want to add there own values so UKDW for example they can do but assign a macro to a button that will add this to my range on a seperate sheet but also will add another case to the macro above.
So if someone entered UKDW_AMOUNT as DECIMAL 15 2 then clicked "Add to Domains" Button this will add UKDW_AMOUNT DECIMAL 15 2 to my list on a seperate sheet but also update my case selection macro.
View 2 Replies
View Related
Jan 30, 2007
I am trying to make a spreadsheet where I use a drop down menu for several of my vendors. When I select the Vendor's name from the drop down menu (for example in A1), I would like A2 to display that vendor's phone number. But when I switch vendor name from drop down list in A1, A2 would need to reflect the new vendor's contact info.
View 7 Replies
View Related
Oct 29, 2009
I have a cell $A$1 that contains a value, CLIENT or INTERNAL
I also have 2 named ranges, CLIENT or INTERNAL
I would like it (using Data Validation) so that the named range being selected for the list dropdown in cell $C$1 is the value of the cell CLIENT or INTERNAL cell $A$1. Tried indirect but not working with named ranges?
View 9 Replies
View Related
Jan 30, 2007
I am trying to make a spreadsheet where I use a drop down menu for several of my vendors. When I select the Vendor's name from the drop down menu (for example in A1), I would like A2 to display that vendor's phone number. But when I switch vendor name from drop down list in A1, A2 would need to reflect the new vendor's contact info.
View 5 Replies
View Related
Jul 8, 2014
I would like to create a spreadsheet that allows me to have a drop down list (in this case I diagnosis - from a list of shoulder, knee and ankle). I have used data validation to do this part. I would like to then have the next column automatically select the appropriate outcome measure (shoulder = DASH, Knee = Berg balance, Ankle =BPI) and display this next to the diagnosis and in the final outcome measure box. I would then like this to limit the possible entry details for the score boxes both at initial assessment and final (see D14, D15, D16 respectively).
I have attached a work sheet too - OP outcome measures.xlsx
View 3 Replies
View Related
Jan 3, 2009
A list in A2 of Sheet 1 of workbook has values "Select", "Yes", "No". How can I get the functionality using VBA so that until a certain rule is met (say A1 becomes 1) selection of items in the list is disabled? (Or any selection of items in the list returns a value of select only?
View 4 Replies
View Related
Nov 11, 2008
I have attached my problem workbook in explanation, I need help of pulling values from particular data by referencing selection in drop down list via some formula.
I thought about using the SUMPRODUCT and VLOOKUP but couldnt reference the values in drop down list.
View 4 Replies
View Related
Aug 19, 2009
My organization whats to provide other a excell spreadsheet ( see sample attached) with pick list for certain cells. We have successfull completed adding the pick list. HOWEVER, at times we would like the end user to be able to pick multiple choices form the the pick list
In the example - in column c the user can pick from the drop down list
A
B
V
or
W
However we want the end user to be able to select any combination, single choice, multiple choice ect
In this example with the above pick list created
How can the end use pick A and W or A, V and W etc
View 10 Replies
View Related
May 6, 2014
I am trying to create 2 drop-down lists (based on named ranges), where the contents of the second selection change based on the first selection. On one sheet, I have a list of equipment that is quite long, but is broken up by categories. I have named ranges for all the category names, and the equipment in each category. On the other sheet (user side) I made the first drop down the list of categories, and would like the 2nd drop down to be the pieces of equipment that correspond with the chosen category. I have tried using data validation and nesting IF formulas, but it only works for the first 4-5 categories, bc my formula is longer than the Source field allows in Data Validation. Any other way I can make this work? Can I use a macro for this? If so, how to write it as this would be my first macro
View 9 Replies
View Related
Feb 5, 2010
I have a budget document that has a selection (Named Range with list items in a drop down) Approved, Rejected, Awaiting Approval or Blank. What I would like to do is set a process that could approve all Awaiting Approval. My thought was to create another choice box at the top that allowed the user to choose approve all awaiting and it would select every matching item that was Awaiting Approval and change it to Approved. At the same time I would like it to set the date and time, this could just copy what I put in an associated field or be real time.
View 9 Replies
View Related
Sep 13, 2006
is it possible to create a list of parts from a selection in one drop down box
ie
i have 1200 parts with descriptions etc in list . using a drop down box i want to select and create a workto list.
ideally this list would start on another worksheet starting on row 10
View 6 Replies
View Related
Oct 11, 2007
want a list of the defined names in a selection. So lets say the range is "A1 to G60". I would like the to see a list of each cells name and the associated address.
View 8 Replies
View Related
Feb 13, 2008
I created a userform for budgets. Currently the way that the user selects the year for a particular line item is a combobox. The combobox is filled from a textbox, where the user inputs the project duration. For example if the user put five years into the textbox, the combobox would have years 1,2,3,4,5, and a default of all years. I want to change the combobox to a multi-selection List Box. I changed the sub that loads the current combobox to this:
Public Sub ComboLoad(cboExpense As ComboBox, cboJob As ComboBox, _
ltAp As MSForms. ListBox)
Dim i As Integer
ltAp.Clear
If Len(UserForm2.txtYears) = 0 Or Len(UserForm2.txtYears) = "" Then
ltAp.AddItem ("All Years")
Else
For i = 1 To UserForm2.txtYears
ltAp.AddItem i
Next i
ltAp.AddItem ("All Years")
End If
ltAp.Text = "All Years"
'ltAp.value = "All Years"
I used to be able to select a value for the combobox, (the default of all years), but I get an error if I include that part of the code now. I wanted to know how I can make this selection by code. Also, the bigger question for me is how do I deal with multiple selections that may or may not be sequential. As an example, for the travel section, there may be a particular expense that will occur in yrs. 1,3,5. I found some info about referring to the position in the array, but it seems like this will constantly change. I could imagine doing case scenarios, but it seems like there would be too many potential possibilities to cover.
View 5 Replies
View Related
May 31, 2013
is there a way to return a textbox full of information based on a selection from a dropdown box?
View 4 Replies
View Related
Jun 4, 2014
I am creating a form using Excel 2007/XP, and am trying to make it easy to use for both people who want to click and people who want to type. I have a series of list boxes in the form that make it easy for the clickers, but I want the typers to be able to tab into the box and make a selection. For example, if the choices are Apples, Pears, and Grapes, I would like a user to be able to tab into the box, hit P and tab to the next box and have Pear be selected.
View 2 Replies
View Related
May 31, 2008
One worksheet will have a library of job elements for assembly process with standard times on it.For example:Pick up a bolt(0.621m),install gasket(0.231m) etc.
The main worksheet will have a dropdown list which will list all the job elements discussed above.It will also have the quantity.So in otherwords,to pick up one bolt the time would be 0.621 minutes.But if anyone picks up 4 bolts the time would be 2.115 minutes,which can be calculated by the formula.So I want to display the job element,qty and the time in three separate rows.This worksheet will also calculate the total time for the assembly of the components which might contain more than thousand job elements.
My question is how do I ensure that picking up any of these job elements will give me the correct time.Is this something that can be done by formulas or anything thats built in excel or I need to run a macro or VBA to run some codes for IF...ELSE....THEN statements.There are too many conditions like If pick up one bolt time is 0.621 minutes,if pick up 4 bolts time is 2.115 minutes or if pick up a gasket time is 0.231 minutes.
View 9 Replies
View Related
Apr 24, 2009
i'm looking for is that I have two lists via Data Validation, and when someone changes their selection in list A, i'd like for list B to auto-delete whatever value it had in it.
Also, on a different topic, i'd like to know how to hide certain sheets in a workbook from public view.
View 3 Replies
View Related
Dec 6, 2012
There are multiple training sessions that will be rolling out in Q1 13 and my manager needs a way to track which empolyees have been to which training sessions. Easy enough. He wants something extremely clean looking, but obviously efficient. What he described to me (his vision) is to have the training sessions listed into columns with drop down under each that contain every employee's name. So when a training session is held, he can easily click the drop down beneath the session title and select multiple persons that were in attendance. Right now I just have all the employees listed in column A and all the training sessions listed across the top and anticipated just putting a "x" in the box for the session that each person attends. This will accomplish exactly what he's looking for, but if what he's describing is remotely possible I would like to do that.
View 2 Replies
View Related
Jun 3, 2008
I haven't used buttons much.
I would like to create a list of projects in column A.
Then the user would select one of the projects. This can be done by clicking on the corresponding cell in column B. So I would lkie to see buttons in column B for this. OR if someone can suggest another way, e.g. highlighting the project name in column A or putting an x in corresponding cell in column B.
I can make this last scenerio work, but I don't know how to assure that only one project can be selected at a time.
In other words if I have selected project in ROW 12 and then I want to see project in ROW 17, I should be able to select 17. And 12 should be deselected automatically.
View 10 Replies
View Related
