macro to searc over multiple workbooks and export to specific workbook

[rommel89]

Hey guys

I am new in town.

I have ben workin on macro that

Search over customer numbers in multiple workbooks consist customer data( this workbooks are in single folder) (do you think vlookup is ok for this?)

Secondly I need this macro to export each data to specific workbooks which named after customer number.

I have another macro for these customer datas . I have to make a kind of template in macro to export these datas to my specific workbooks.

I need your help in everyway whether code, pattern or algorithm.


thanks anyway

 

[oldbrewer]

so for customer1 you want to export that row to a sheet called customer1 in the same workbook ?