I found this macro in google.. please edit this for my needs,,
I have some specific procucts in coloum A in sheet (data), If that product was found in Sheets("allproducts"), copy all the rows and create a new sheet on the product name and save the excel.
Please help me in this..
Please Login or Register to view this content.
Bookmarks