I am not really sure what I need for this trick. After several hours of
searching, I thought I would just ask.
I have a drop down list:
Code Code Description
CL01 Client has not provided the files/data required to complete manual(s)
CL02 Client has not made decision on Programming/Database Management
CL03 Client has not made decision on Particular Subject Matter
CL04 Client out of Office/on vacation
CV01 Server down - unable to retrieve documents
CV02 SME - Out of the Office

I want them to be able to choose which code pertains to their situation so
they need to be able to see all this information. But in the actual cell
where it is chosen I only want the code to populate the cell. The Description
I will have populate on another worksheet. Any suggestions? I have even
attempted using the =LEFT or =RIGHT functions. Keep in mind that I havent
been able to crack open the book "VBA for Dummies" - so please be easy.
Where do you get information to learn VBA anyway? I took Basic Programming
back in the stone ages - but I dont remember any of it. Thanks ahead of time.