Moving data between worksheets
 

Hello,

I have a workbook that tracks each individual's completed reports. I have a
master worksheet and one worksheet per employee.

Once a day I have to auto filter the master list by name and copy and paste
all of that individual's reports in their respective worksheets.

How would I go about writing a macro to match each individual's name and
copy the row it to their own respective worksheet? Each Individual worksheet
has been renamed to the individual's last name (which matches the name field
in the master sheet)

Any help is sure appreciated.

Thank You.

-Joe