Hi
Looking for a way to search thru the workbooks and find criteria and add workbooks that have that information in it.
Example:
Looking for Zebra in all workbooks
Return: Book1 Book3 Book5 (this to written into a cell of another workbook)
Note :"Return" indicating the Books that contain Zebra in it
Is this even possible ?
Thanks in advance
Bookmarks