Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
validation? VBA? Lookup table?
Hi,
I have a problem that I thought would be simple to solve, but I'm having a little diffuculty with it. I have a range of values that I want to pick from a drop-down list. I've been using a named list with validation for this. It works swell. The data are just text which represent time sheet codes (i.e. RT, SDR, etc). Now I'd like to be able to have the drop-down list contain the actual descriptions of the time codes, and when selected, fill in the time code itself (i.e. the list contains "Regular Time", "Sheduled Day of Rest", but when selected, RT or SDR is what appears in the cell). Can I still use validation for this? Do I need to know more about Visual Basic? Can someone help me out? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation and Lookup | Excel Discussion (Misc queries) | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Using Validation Ref # within LOOKUP | Excel Worksheet Functions | |||
List Validation Lookup Table Help Please | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |