Hi,

I have a workbook with about 10000 rows of data for about 100 suppliers in Sheet1 and about 15000 rows of same Suppliers payment details in sheet2.

What I am doing now is:-
Filter every supplier names in Column A of sheet1, copy all the rows and paste in sheet1 of a new workook & Again copy the
Payment details of a same supplier from master file sheet2 and paste the same in sheet2 of this new workbook then save the files with the supplier name as file name in my documents folder

Can someone help me with the code, that filters each suppliers data from sheet1 & 2 and paste in new workbook sheet1 & 2.

Thanks for your help
Arvind.

Cross Link:- http://www.mrexcel.com/forum/excel-q...es-column.html