Hi BerkshireGuy,

If the validation list is in a different worksheet, give the list a name and
use the name in the data validation's source box.


---
Regards,
Norman



"BerkshireGuy" wrote in message
oups.com...
Hello,

I've built some VBA code that builds a seperate workbook for each
agency to show their data.

However, I want to add a dropdown field in column K in which the user
can select a reason code from a list. This list of reason codes should
be in a seperate worksheet called "reason codes"

Can this be down with validation?

Thanks
Brian