Hi,
I have a folder with a seperate workbook for all the branches in our company, Liverpool, Manchester etc.
In each workbook is a simple table that shows sales data, a sales number, name, email address, stock code etc.
I then have a master workbook that has a list of stock codes in it.
I need to be able to create a macro that searches through all of the workbooks and if it finds a matching value for any of the stockcodes, copy that row and paste it to a new worksheet in the master workbook with the title of the worksheet being the same name as the file name it found it in, with the rows of data throughout.
I had something similar that searched for one key phrase and returned a row, but i need it to search for any string from an entire row of strings.
Hope that makes sense and any help would be much appreciated.
Cheers
Bookmarks