Bruce_B_2002
New Member
- Joined
- Oct 17, 2002
- Messages
- 3
At our office we have a large Excel spreadsheet (as in 39,281 rows) which lists graphics files available on our server. Each column represents their filename, file extension, their subject, the project they're related to, their path on the server, etc.
I need to create a "search engine" in Excel that would allow a user to enter anywhere from one to six criteria (each criterion has its own separate entry field) in order to find the desired graphic file from this enormous spreadsheet. These six criteria match column categories from the spreadsheet. The more criteria entered, the more refined the search. For example, let's say a user is looking for a picture of an Army M1 tank, preferably in a *.bmp format. The user could simply enter “M1” in the Subject field, which would then search for any files and formats having that designation. However, if the same user enters “Tank” in the Type field, “bmp” in the File Extension field, “M1” in the Subject field, and then clicks a "send" button, the search engine will only return a more refined list of *.bmp files of Army M1 tank images and show each file’s path.
I hope this makes sense. I'm just wondering if there's a macro out there on the internet that is closely related to this type of function and "search bar" interface. I haven't been able to find one. I would welcome ideas on where I might find related macro instruction as well. Anyone's help or guidance here would be very much appreciated. Thanks.
I need to create a "search engine" in Excel that would allow a user to enter anywhere from one to six criteria (each criterion has its own separate entry field) in order to find the desired graphic file from this enormous spreadsheet. These six criteria match column categories from the spreadsheet. The more criteria entered, the more refined the search. For example, let's say a user is looking for a picture of an Army M1 tank, preferably in a *.bmp format. The user could simply enter “M1” in the Subject field, which would then search for any files and formats having that designation. However, if the same user enters “Tank” in the Type field, “bmp” in the File Extension field, “M1” in the Subject field, and then clicks a "send" button, the search engine will only return a more refined list of *.bmp files of Army M1 tank images and show each file’s path.
I hope this makes sense. I'm just wondering if there's a macro out there on the internet that is closely related to this type of function and "search bar" interface. I haven't been able to find one. I would welcome ideas on where I might find related macro instruction as well. Anyone's help or guidance here would be very much appreciated. Thanks.