Search & copy from one sheet to another?

Hi everyone,

This is my first post here, so I hope I'm doing it right.

My work consists of keeping track of a lot of paperwork, and my company currently has 2 separate worksheets to do so. One that keeps track of our office copy, the results and the fee we charge our client. The other keeps track of our employee's copy, the results and what we pay them.

I'm trying to incorporate them both into one. I can't figure out the details on how to have excel search the first sheet and copy certain information to a sheet for each employee. I want to have it search for the employee number and, if found, copy it to the employee's sheet (named by number). So, for example, all of the employee numbers are entered in column F on sheet1. I want it to search for 50, 55, 60 (employee numbers) and take all rows that are found for 50 and copy them to 50's sheet and so on.

I think I've figured out that I need to create a button and assign a macro to it, but I don't know how to create a button or exactly what the macro would need to say.

Also, (I know this is probably asking for too much, but I'll try anyways), is it possible to set up the macro that it would not copy duplicates? It's not a huge deal if it won't, but it would make my life a lot easier.

Any help would be greatly appreciated.

Thanks!

~Amy

Amy

See if this example file will get you started.

I've put some data onto a sheet called Main. In the Employee sheets, a sheet activation macro uses the advanced filter to bring in the relevant unique data for each employee.

rylo