Hello,

I have a table

EmployeeID Assignmentment
1 6
1 7
2 5


The criteria range is

EmployeeID Assignment
2

The CopyTo Range keeps showing

EmployeeID Assignmentment
1 6
1 7
2 5


Why?!! It should show:

EmployeeID Assignmentment
2 5