I have a project where I need to populate specific worksheets/workbooks based on a sales person's sales ID number. This is an ongoing weekly report and I need code to return multiple criteria based as few as one sales ID number to eleven different sales ID numbers for the same sales person. I.E:

Bob has sales numbers 4011,4012,4015,4025, etc...

Bill has sales number 4065

Jill has sales numbers 4078 and 4080

Then I need to populate separate worksheets/workbooks with multiple data fields to track what they specifically sold based on aformentioned sales ID numbers. the data header is as follows:

Inv # SO# Inv Date Date Shipped Cust # Cust Name(Ship To) Addr 1 Addr 2 Addr 3 City

(Cont)

St Zip PO# FOB Terms Ship Via Item # Item Desc Qty Ext Unit Price Back Ordered Sales Tax

(Cont)

Freight Total Customer Type

Can someone help out with this as it is way beyond my skill level. I came up with a formula that will work but it leaves blanks and is just too many manual moves to do on a weekly time efficeint basis. If I could have this automated that would be great. I can always filter the data then copy and paste it but that would take a while too. If there is a way to automate this functionality that woukd be great. Thanks!