i wana to create a macro where i have a list of name in an excel sheetb tab 2
and in tab 1 if i type a few letter of a name it should give all d name statrting from those letter in a dropdown at d same place (like if we type something on google it gives some possible combination ) and we select d appropriate from the list.
if u have some solution for this kind of macro please let me know
only one thing is important search box for the name and database for the name list both are in two different tabs in d same excel sheet.