Hello, Every week our company gets a planning schedule that has a list of part numbers in column A and other information such as quantity and ship date in the other corresponding columns.

These parts are handled by different people in the company so what I want to do is split up the large file into smaller files that only have each persons parts.

I have read other forum posts that show macros on how to do this but it is actually scanning the file for a persons name and then creating a file based on the name, in my file there is no names only part numbers.

I believe it would work something like this; we would first need to populate a list with all possible part numbers and their corresponding employee. Then each week when the planning sheet comes in it would scan that list and dump the corresponding parts into a file based on the persons name. I just don't know anything about VBA or the nomenclature it uses.

Any help on a code for this would be greatly appreciated.

Thanks