Thread: Help macro copy filtered data to new workbook

Hi everyone,

I tried looking online but couldn't find a solution.

Basically I have one master workbook that has 6 product areas on different sheets.
I have around 20 clients that will all be on most of the 6 tabs, and that data will keep getting added to as they make more orders, so they will have multiple entries.
I then have 20 excel files (one for each customer), and they also have the 6 product sheets on.
I'm trying to get a macro to filter the data on my master workbook by each customer and have their relevant data copied in to the 6 sheets on their customer named workbook.
Any ideas?
Any help would be much appreciated!

Looks like you want to track orders from clients and products they purchase. Instead of using so many files and sheets, why don't you put all those information in ONE big worksheet and use a pivot table to get the information you want about a particular client or product.