This is a repost since its been about an hour and my origional still hasn't shown up.

I am somewhat versed in macros at this point - I know alot of the basics. What I am mainly looking for here is some direction about how to solve my problem.

Here is the situation I have:
1. I have a workbook with 2 sheets, sheet one is three lists of machine codes, sheet two has the data I need to filter
based on there sets of codes (about 40,000 rows).
2. For the three lists on sheet one, there will always be only three but the number of codes in each will vary each time
with anywhere from 1 to 10 codes.

Question:
What I have to do is filter the main data on sheet two into three seperate workbooks, one for each set of machine codes (the values to filter will be in column "R"). That data will need to be on one sheet in each book, so it has to copy and paste to the bottom. I know how to do auto and advanced filters and copy and paste to bottom row, my problem comes in with the variable number of codes in each list. My only thought is to use an array and load it with the values from each list, but I am not strong knowledge wise in this area and would need some assistance.

I know I can make this work, but I am stuck as to how to go about it, this above idea is my only thought and I am currently working in that direction, but any advice on the best way to set this up, idea wise, would be greatly appreciated. Also any advise on how to set up and load an array with my machine codes if that is what I need to do, would be greatly appreciated.

Thanks for any advice,

Jim