Transfer a list of info dependent upon variables
 

Here is a hard one!!!

I need a function that will read a range of cells and and find every one
that matches a cell on another page. Then it needs to take all the info from
the second worksheet and transfer it to the first. Also not have any
duplicate account numbers.

Example:

2nd worksheet:

Account Date Cycle Amount
1141 11/2/2005 2 $25.00
1231 11/24/2005 5 $30.00
12312 11/8/2005 2 $45.00
1141 11/24/2005 2 $35.00

What I need it to do is read all the cycles in the list - choose say cycle 2
and return all the info (account, date, amount, etc) for that cycle over to
the first worksheet but not have any duplicate account #'s - if there is a
duplicate it only needs to bring one over - doesnt matter which one.
--
na