Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validtion
I have a column in my worksheet in which I am using data validation with
V-lookup from another worksheet. When I click on the drop down list in the column it of course shows the listing from the other worksheet. In the next column in the lookup worksheet I have a reference code for the item in the first column. What I would like to do, is when someone clicks on the drop down list in my MAIN worksheet, and selects a value, I would then like it replaced with the reference code that corresponds with the value being clicked on. If this does not make sense, please let me know and I will try to explain it again in another way. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data | Excel Programming | |||
vlookup or sumproduct formula for 2 columns data validtion | Excel Worksheet Functions |