Dear all,
I have a directory of excel files that I would like to search/loop based on a variant that I set to a particular sheet and cell. Below is my code, can someone help me with this? And after searching for the particular I would like to copy a particular cell in a worksheet to my active sheet's particular cell too. Any assistance would be great.

Cheers
Brad 

Please Login or Register  to view this content.