Need to search and display, data from multiple excel workbooks

HI,

Can some one help me with a VB / Macro to find a specific value from multiple excel workbooks. Below are the criteria

1. The files will be maximum of 10 nos, and it needs to be selected / inputted by the user at the time of running the code / script
2. the result should display , file name in one cell and the searched datas' entire row. For eg: the seach parameter is abc, it should find the text ABC in all the files chosen and display the entire row where the data is found.

abc 1 2 abcdefgh qwerty 123 23 kaljkh ashqj

Considering yes to all your above Questions, can you please provide VB macro code, if you have.

Hello,

1. Yes, the files to be searched are in a single folder
2. No the search column is not A in all Workbooks it differs, maybe if we can specify that while selecting the files could be fine
3. the search will be in multiple sheets
4. the search will be from for the entire cell content, may be a pop up at the time of execution of code for longer strings could also be fine
5. the search should not stop when it finds one match, it needs to loop until all clear match found.

I've attached a framework as to how the macro should be. Any inputs / clarifications highly appreciated.

Hello Jerry,

the initial plan was to pre-select the files, later i thought entire folder search could be easier. Either way iam ok... Either if we can workout by folder or by pre-selected files!!!!1

Hmm.. wen i tried to run the macro..it prompted for string to search and location of the folder, but i didnt get any result. i've tried the whole and partial match as well.