Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I list info from one worksheet to another..... | Excel Discussion (Misc queries) | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions | |||
Dependent List Query | Excel Worksheet Functions |