Hello everybody,

I have a database of around 105 equipments. Since, this is a large database, I am thinking of merging them in a single file .Moreover, i want to create a drop down menu or say a search option where if you enter the equipment number you are directly routed to that file.Being a beginner in Excel, I don't know how to create it. Please post suggestions.