Hi ppl,

i have been trying to find a macro to pull retrieve data from multiple work books from a same folder.

The criteria is i need to search for a particular string on each workbook sheet(a particular one), the search string could be any where on the work sheet and also some of the cells are merged, if it matches it has to copy the whole row on to a master sheet where it has the first column with file name on it.
Iam new to VBA Scritping and it is kinda complicated as we have to search a string which can be anywhere on the sheet(row or column not fixed) & also with some of the cells being merged & also there the string searching is repeated.

Thanks in Advance.