You could probably adapt this code to do what you describe:

http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy


"trward79" wrote:

I am trying to filer a sheet by a value of a cell on a second sheet.

here is what I have going on.
Sheet2 has employee vlaues for income and an id number associated with each.
Sheet3 has a list of employee numbers and I need the employee number in
Sheet3!$A2 as the sort cirteria.
This would give me all the info on Sheet2 I need, then I need to replicate
for the rest of the values on Sheet3 to get the correct info.