Excel search

Hello,

I am a fairly advanced Excel user, however, I have a question that has me stumped (it could just be a long day).

I want to create a spreadsheet that is used as a "search" sheet. What I mean is, I want to be able to type in fields (such as First Name, Last Name, etc.). Using the information that I provide to the sheet, I want the sheet to then check other Excel files, located on a common server, and retrieve student information, such as courses registerd, completed, and grades. The Excel sheets with all the student information has already been created.

This is to solve a time issue when I have a request about a student's status, I have to manually use the "Find" tool and go through each of the Excel sheets that currently exist (1 per month dating back to 2000).

Any help that could be shared with me would be greatly appreciated.

Thanks

Chris

You could try opening the other workbooks sequentially by macro. My download page has some code which will allow you to generate a list of files in a specified folder and all its sub-folders so your macro would continue to work even though the list of files is growing.