jmeador2
02-16-2017, 11:23 AM
Column C in the attached workbook has a list of security descriptions and I want to only be able to enter exact matches in column A of a seperate workbook but I want there to be an autocomplete feature that helps users find the exact way it needs to be typed but entering the beginning or key words. So say someone wants to enter "CBOT 2 yr note mar 2016" They can start typing "2 yr" and they will see all possibilities that match so they can pick the correct one. Can someone please help with this? Thank you