Perhaps I am missing something but what are you talking about??? Are you
using formulas or are you doing an external query. Is your query parameter
driven. If it is an external query post your SQL. If it is a formula post
your formula.
--
HTH...

Jim Thomlinson


"Webtechie" wrote:

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