I have a spreadsheet that is updated nightly for all the sales orders for the current day. In column C is the sales reps code for the customer orders that are assigned to that sales rep. What I need to do is build some code that will copy only the rows (and headers) for each rep and email the file to that rep. I have a separate tab in this file that has a list of the codes and the reps email addresses. So I need to find a way to copy just their orders for the day and email them the list. The sales rep codes are not very cut and dry though. There can be multiple reps assigned to a specific customer account. And they are identified in column C like this: T-V. The "T" is one rep and the "V" is another rep. If there is only 1 rep assigned to a customer then there will only be one code in column C like this: "T". There are many different variations of these codes since we a few sales reps. So I need to use this separate list and find all the records whether it be the first letter code or the second letter code in column C and copy those rows to a separate file and email it to that rep. So there could be rows that go to multiple sales reps. How can this be done using VBA code?