Hi All,

I have a table which represent a simple sales channel data.

[AGENT] [PRODUCT] [CURRENCY_VALUE_GROSS]

it normally consists of 4500 rows depending on month.
Every week i have to split out a new workbook which has a new sheet by [AGENT]. Problem is; every week i do not need to split out the same/all [AGENT], i have a list of them in "Sheet2" column "A" which i need to adhear to.

How to i get VBA to loop through this list on "Sheet2" and paste all relevant data from "Sheet1" by [AGENT] to a new workbook with the [AGENT] names as new worksheets?

I've found some code which will loop through an entire variable and sepreate as sheets but i'm not qualified enough to adapt this to just split my data from "Sheet2"

Hope someone can help - my first post