Guys (and gals),

I looked around for a while but couldn't find an answer to this question; I hope that it is not a duplicate post.

I have say 100 rows on worksheet A (which happens to be data that I have pulled out of a SQL database) which contains ALL of my data. However, for reporting purposes and to send different sections of the data to different people, I am currently manually copying and pasting just a few rows of the 100 that I mentioned above into a separates worksheets. I would like to know if I can automate this.

For example, of the 100 rows of data that I have, 10 or so might all be for one employee with the last name "Davis" and each of the rows that pertain to him have a cell that reads "Davis." Is there a way to get excel to paste only those rows that meet the criteria (in this case, "Davis") into another worksheet. Ideally, I would like to automate it so that once the entire data is placed into worksheet A, the other worksheets in the workbook would each pull the data for a different employee.

Thanks,
tx