Need help AutoFill-ing Validation List

[DJBittner]

Attached is Workbook Tables.xlsm. In Worksheet TED, column D I have a Validation List to select Department#s (Bus Units). Rather than having the field going into a drop down automatically (upon entry into that column), I would rather key-in the Dept# and then have a dropdown positioned to that place in the Validation List. Since there are more than 700 records in the Validation List the current method is a pain.

Thanks for any attention. ~ Dan

[jaslake]

Hi Dan
I messed around with this for a bit 'cause I've always liked the Contextures code http://www.contextures.com/xlDataVal11.html#Setup

I think this is approaching what you wish to do. You'll need to play with it. If somethings not working, perhaps we can fix it.

Let me know.