Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Data Validation Manipulation
drop down selects Hello, I currently have a drop down box which list location names. The problem is the location names are very generic (only part of the location info). What I would like to do is have a drop down list actually list the full location name but populate the field with the generic name when selected. I could add another column but this file will be used as import data and the extra field is not part of the extract layout. Ex. Generic name:T100 Full location name: Trumbull 100 (specific trumbull address) User's would select trumbull 100 from the drop down list, but the name T100 would actually populate the field. I tried to reference the generic range but keep on getting a circular reference error. Can this be done? -- pyarb ------------------------------------------------------------------------ pyarb's Profile: http://www.excelforum.com/member.php...o&userid=26803 View this thread: http://www.excelforum.com/showthread...hreadid=400570 |
#2
|
|||
|
|||
You could do this with programming. There's a sample workbook on my web
site that shows a product name and code in the Data Validation dropdown list. After an item is selected, the cell shows only the product name. You may be able to adapt this to your workbook. On the following page: http://www.contextures.com/excelfiles.html Under the data validation heading, look for 'Data Validation "Columns" pyarb wrote: drop down selects Hello, I currently have a drop down box which list location names. The problem is the location names are very generic (only part of the location info). What I would like to do is have a drop down list actually list the full location name but populate the field with the generic name when selected. I could add another column but this file will be used as import data and the extra field is not part of the extract layout. Ex. Generic name:T100 Full location name: Trumbull 100 (specific trumbull address) User's would select trumbull 100 from the drop down list, but the name T100 would actually populate the field. I tried to reference the generic range but keep on getting a circular reference error. Can this be done? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thanks, Debra!. I unzipped your worksheet. However, when I click on the dropdown and choose a product, the product and id remain, does not automatically fill in just the product name. Also, I selected enable macros. -- pyarb ------------------------------------------------------------------------ pyarb's Profile: http://www.excelforum.com/member.php...o&userid=26803 View this thread: http://www.excelforum.com/showthread...hreadid=400570 |
#4
|
|||
|
|||
Perhaps events have been disabled. Does it work if you run the MyFix
macro that's also in the workbook? pyarb wrote: Thanks, Debra!. I unzipped your worksheet. However, when I click on the dropdown and choose a product, the product and id remain, does not automatically fill in just the product name. Also, I selected enable macros. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
Running the macro, it still doesn't work. I've tried using your code for my workbook and it kind of works, but with a delayed response. If I click on the drop down , choose my selection, it does't populate that cell with the corresponding name unless I pop back into the cell. If I leave the cell and then go back to the cell than it updates the cell with the corresponding name. -- pyarb ------------------------------------------------------------------------ pyarb's Profile: http://www.excelforum.com/member.php...o&userid=26803 View this thread: http://www.excelforum.com/showthread...hreadid=400570 |
#6
|
|||
|
|||
Does the code work correctly in the sample workbook that you downloaded?
pyarb wrote: Running the macro, it still doesn't work. I've tried using your code for my workbook and it kind of works, but with a delayed response. If I click on the drop down , choose my selection, it does't populate that cell with the corresponding name unless I pop back into the cell. If I leave the cell and then go back to the cell than it updates the cell with the corresponding name. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation screen size | Excel Discussion (Misc queries) | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions |