C
Cody
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.
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.