Thanks for your help. I tested the combo box setup and it did work.

I did have one problem with it, however. After entering part of the name, autocomplete recognizes what it should be. But, when I hit enter or tab, it doesnt move on to the next cell unless I actually click into a different cell. Is there anyway around this?