Searching in Different Excel files

F

frikkie

How can i search in different workbooks in the same folder fo
information?

I have 1 jobnumber in each workbook with a differnt date. Now i want t
create another workbook where i type in the job number and it mus
display the excel workbook name with the job number and the date. I
this all possible?
For now i would just like to search different workbooks and when i typ
in the jobe number it can go to the location in every workbook.

than
 
Top