Filter by value of cell
 

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.

Filter by value of cell
 

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.