Hi all.
I need some help, I have in one folder about 50 workbooks for the various Dept's in our company. Each workbook contains about a dozen worksheets with all the employees names, addresses, employee ID etc on one sheet and various other named functions on the other 11 sheets in each workbook. I'm trying to create one sheet(book) that I can use to search for employees by name or employee ID or City etc, across all the workbooks in the folder.
I've been racking my brain trying to figure out how, I'd like to have a box where I enter the name or city or dept and the click a button and have it search my workbooks and display all the matches in another box below. Is this even possible in excel? I really don't want to have to build an access database and import all the workbooks as they change frequently and are updated by the various depts.
|
Microsoft Office