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
ADVERTISEMENT
Jan 25, 2008
I found many examples on this forum of how one can pull in data from closed workbooks, or copy it and have it stored in the active sheet. So far so good, but I need a solution which would do the opposite - I need the macro to take a range of data form the active sheet store it in a closed workbook and save any changes in the target workbook without opening it.
View 2 Replies
View Related
Aug 17, 2011
Is it possible to do a drop down list that allow user to select pre-defined selections but everytime when a selection is chosen, the list reduced?
Example,
I have can choose Apple, Orange, Durian and Mango.
The drop down can only select these 4 fruits.
So there are 4 cells in Column A1, A2, A3, A4.
A1 selects Mango and then A2 will only have 3 options to choose. So until the last cell, he can only choose the last fruit left.
A1, A2, A3, A4 are not selecting in descending order thus it could be A3 selecting first, then A2 and then A4.
I'm using excel 2007
View 13 Replies
View Related
Mar 9, 2012
I am trying to limit the user from selecting only what has been selected from the first selector. The selection are based on a drop down (data Validation list)
Excel 2007BCDEFGHIJ1LOOKUP Table2Should only allow from 3only what availble from First SelectorBus/Cntry Level 2Bus/Cntry Level 14ALLALL5First SelectorSecond SelectorAPACALL6TerritoryAPACAPACAPAC Regional Office7APACAsia Licensees8APACAustralia9APACChina10APACHong
[Code] .........
View 5 Replies
View Related
Jun 27, 2014
I would like to be able to limit a drop down list's contents based on a user's selection in a different drop down. I am using Excel 2003, and I know how to do this in Access, but I can't figure it out in Excel. Basically, I have a list of themes in one drop down. The user picks a theme, and goes to a second drop down which is a list of sub-themes attributable to that one theme and no other theme.
View 1 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
Jan 20, 2013
I have a dropdown list selection on the form for types of machines. The list of machines, their sizes and related noise level are in a chart on worksheet 2 and I'd like to automate the form so that when the machine is selected, the related noise level auto populates.
The dropdown box has been put in the form using the data validation function.
View 7 Replies
View Related
May 2, 2014
For example, I have a master sheet that has a drop-down list of the months January and February, which have their own sheets. I am trying to populate the sales of the week 1, 2 ,3 ,4 in the master sheet based on the same data for the month chosen.
View 2 Replies
View Related
May 15, 2013
I am looking to write a code to lock/unlock cells based on values selected using a drop down list (see attached Excel) For example if Netherlands is chosen as the Country (Column A), then except for the columns Amsterdam (column B) and Eindhoven (column C), all other columns must be locked. Similarly, if India is chosen as the country from the drop down list, then only the columns New Delhi and Mumbai must be editable for the user, the rest of the columns remain locked.
I tried tweaking some of the lock/unlock codes around, but got lost especially with getting to run the macro - still trying to come to terms with running a "Private Sub Worksheet_SelectionChange" function in the sheet from "Module"!
View 1 Replies
View Related
Nov 29, 2010
I'm creating a configuration tool for instrumentation that has several options. Many of these options are dependent on one another. To summarize, I need to:
*Conditionally lock cells (and populate with "N/A") OR allow selection from drop down list - the list exists, it's the locking and auto-population I'm struggling with
Example: If A1 = No, then B1 = "N/A" and is locked, else allow selection from drop down list in B1
View 3 Replies
View Related
Feb 9, 2012
If I make a selection using a drop down, can I have it auto populate another cell with information associated only to the made selection? For instance, if I select January from drop down in A1, I want it to auto populate B1 with 100.
View 2 Replies
View Related
Jan 8, 2014
I have some data validation drop down lists in excel, I can tab through all the lists but I have to press alt + down arrow to show the list, Is their a way it can be automatically shown as soon as I focus on the tab.
Check the attachment: Survey.xlsx
View 1 Replies
View Related
Nov 21, 2012
I am new to VB macros, I am trying to figure out how to color a tab Green based on a selection from a drop down list.
View 9 Replies
View Related
Jun 14, 2014
I need to make a dropdown list (I know how to do that) and based on that selection, I need some cells below to automatically complete. How can I do that? Is it possible with or without VBA?
View 5 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
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
Apr 12, 2013
I have a workbook that has two worksheets. One worksheet is an input worksheet. A user will select a date from a drop-down list and type in the events that occurred on that date in 8 adjacent cells. The user selects a button that advances date and clears form. On sheet 2, whatever was typed into sheet one is saved via VLOOKUP formula. However, if I try to change something retroactively and select a previous date from the drop-down list, it clears everything in sheet 2 that was typed for any selected day.
View 1 Replies
View Related
Apr 3, 2014
i want to make a dropdown list from excel 2007. I try data validation then allow then list then source but i cannot make the sheet 2 as the source of my dropdown list in sheet 1. i uses excel 2007 and my OS is XP.
View 4 Replies
View Related
Feb 23, 2012
I have cells containing large drop down lists (offering many possible entries). Is it possible to get excel to "jump" in the list or complete the entry automatically? If i start typing "aut", it should the drop down entry "automation". For your information, I just use Define Name and Data Validation to create the drop down list. Is it must be using VBA code or I just can use Define Name and Data Validation which has been I created?
View 5 Replies
View Related
Apr 15, 2012
I am trying to make an excel sheet which has a 2 column drop down. For example I want to have a drop down list in column 1 and when I select "Item A" in column 2 "item A" 's phone number appears. If i select "item B" form the drop down this, "Item B's" phone number would also appear in column 2 and so on. how this is done (if possible) on Excel 2007? I was hoping it could be done from one workbook to another but If it is easier from one worksheet to another then that is fine too.
View 5 Replies
View Related
Jan 27, 2012
I have a question on how I could populate data using a combo box selection in Excel 2010.
For example, I have a table with values in Sheet 1, & below that table there is a combo box whereby another table of values can be populated based on the selection of the combo box.
Maybe to make it clearer...
Table 1
Name | Address | Phone number
Andy | Avenue 2 | 999
John | Road 5 | 998
Combo box (selection of names): John
Data derived from combo box - Table 2
Name | Address | Phone number
John | Road 5 | 998
how I could solve this Also, do let me know if this can be done without the use of VBA.
View 4 Replies
View Related
Aug 21, 2014
Excel 2007 and very new to VBA...
I have a userform (named "QAReviewForm") with a combobox (named "cboSupName"). I want it to populate with my named range "SupList".
FYI, the SupList is found on sheet 2, "Administrative Menu" in column E. E1 contains the heading "Supervisors", and my named range formula is
Formula:
[Code ] .....
When it runs, my form opens and the combobox is there, but nothing appears as options for me to select (yes, I have some values in column E).
View 11 Replies
View Related
Aug 8, 2012
I have a validation list drop down box set up to reference data in a defined name list. I would like to be able to select multiple values from this list to appear in one cell (preferably separated by a comma). For example, the defined name list contains the following data:
Choice 1
Choice 2
Choice 3
Choice 4
I would like to be able to populate one cell with the following via the drop down list: Choice2, Choice 4
Is this possible and if so, how?
View 8 Replies
View Related
Jun 22, 2014
I have a cell in my spreadsheet that I use to control the size of a column. I formatted the cell as a number and added data validation to make sure the number is greater than zero. Then I realized that I need to also allow for the option of auto sizing the column as well. This would require a data validation list type with something like True and False for the choices.
What I want to be able to do is have it both ways. I want a drop down list in that cell with the options Auto Size or Custom. If Auto Size is selected the cell value gets set to that. If Custom is selected I then want to be able to type in a number.
ddl.png
[URL]
Is there a way to setup a cell such that the value is either an item from the drop down list or, entered directly (depending on the list selection)?
I know I can do it with dependent lists but that would require two cells, one for the auto size mode (true/false) and the other for manual width value.
View 1 Replies
View Related
Jun 1, 2011
What I am looking to do is this... (using Excel 2007)
I need to have more dependent lists based on the selection in Column A. (My column B is already set up and works perfectly using INDIRECT)
For example:
Column F would be a dependent list of colors based on the sales rep chosen in Column A
Column I would be a dependent list of managers based on the sales rep chosen in Column A
Column M would be a dependent list of part numbers based on the rep chosen in column A
without using VBA? (If I HAD to - okay, the other person maintaining the sheet would be lost....) I haven't been able to find anything close to what I want to do online - maybe I am just not using the correct terms.
View 4 Replies
View Related
Dec 14, 2012
I have a dynamic drop down list using OFFSET and want to change a selection of cell colors based on the drop down selection. My drop down list is located in cell G4 and the cells I want to change are
=$C$9,$C$10,$C$11,$B$11,$B$12,$C$12,$B$13,$C$13,$C$14,$C$15,$H$15,$H$14,$H$13.
These are random cells. There is no value in the cells, I just want to change the color from green to gray.
View 3 Replies
View Related
Jun 3, 2013
If a user selects certain options from a drop down list created by cell verification (from list), is it possible to display an input box and have the resulting input populate on another worksheet in the workbook? I have an attendance template I'm working with and if a user selects OT (Over Time) then a input box is displayed prompting for how many hours. The overtime is then tracked on another worksheet.
View 1 Replies
View Related
Jun 11, 2013
I'm creating a spreadsheet to keep track of my costs of production in an online game. Within the game there are a range of spawned resources that appear for only a short time before being unobtainable these resources have specific types that is shared between multiple spawns of the resource but each resource spawn has a unique name.
My first worksheet lists all the resources and their various qualities and the later worksheets are meant to allow me to choose from a list resources matching the requirements of the item I'm looking to craft. The example i have shown in the second picture requires Tatooinian Fiberplast and Lokian Wild Wheat to craft so in the Chosen Resource column I would like to have a drop down list allowing me to select the named resource type i would like to use - for Tatooinian Fiberplast the only thing on the list should be Omnitwixi and for the Wild Wheat it should show Fizi and Krad
[URL]....
[URL]....
I am aware there are people with more pressing problems than computer games and as such
View 7 Replies
View Related
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
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
