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