Hello Everyone,

I am really a novice, and I need help trying to copy rows from one sheet into another sheet based on criteria that I have in a separate table.

Here's the story. I need to pull sales data for a bunch of reps, I then need to place each reps data in worksheets depending on which region they belong to. Each rep has about 5 or six rows of sales info that needs to go with it. One caveat is that a total row for each rep is the last line of data for each rep. The total line contains hard numbers, not formulas. That's just the way it gets pulled from our in-house application, and I can re-create the totals if need be.

I am attaching an example of what I would need to do. I would need something that reads the data on the "Original Data" tab, then compares the name in column A to the table in the criteria worksheet to figure out which region the sales person belongs to, and then outputs the rows that have that reps name in it to the appropriate worksheet. I have created a NJ tab that gives an example of what I would need to take place.

Overall, what I need to do is not terribly complicated. I am just cutting and pasting rows based upon what region a sales person is in, but there are a ton of sales reps (I have removed the majority of them to keep the spreadsheet simple), and its quite tedious and leads to mistakes doing it manually.

Any help would be GREATLY appreciated. I am not sure if this can be done with any built-in excel functions or if this requires any VBA scripting (of which I have no experience, but I am pretty tech-savvy).

Please help!

Thanks.

Jan11-Data.xls