Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still needing help with Matching Criteria
Hiya,
Sheet 1 has Debits, Sheet 2 has Credits, I want to run a matching criteria, between the two and the items that dont match, would be put onto sheet 3. Some of the Debits might have lets say 2 $100.00 and the credits might have only 1 ($100.00), how do I make it so that it only pulls the amounts that equal zero. How do I do this automatically (macro) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still needing help with Matching Criteria
If there were only one $100 credit, how would the macro know which
$100 debit to "pull"? Or does it not matter? Do you just want to pull the credits and debits or is there additional information that needs to go with them? Do you want them put onto sheet 3 in sequential rows or in the same row? In article , "D'Anne" wrote: Hiya, Sheet 1 has Debits, Sheet 2 has Credits, I want to run a matching criteria, between the two and the items that dont match, would be put onto sheet 3. Some of the Debits might have lets say 2 $100.00 and the credits might have only 1 ($100.00), how do I make it so that it only pulls the amounts that equal zero. How do I do this automatically (macro) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching criteria and summing | Excel Worksheet Functions | |||
Formual help needing using multiple criteria | Excel Discussion (Misc queries) | |||
Matching Text with With Certain Criteria | Excel Worksheet Functions | |||
How can find a value using two different matching criteria? | Excel Worksheet Functions | |||
student needing help w/vlookup function grading criteria | Excel Worksheet Functions |