macro to compare data sort and delete buys vs sells

[maulik1k]

Hi Guys i have a attached a sheet for which i need to create a macro. I am not sure where to start that why i am listing all the criteria for it. Just as a heads up i am using lines 5 and 11 to elaborate what i am looking for

-first i want to go through the product type and see if any match in the file that i have attached cells B5 and cells B11 match. ( EUR/USD)
-second, if D5 and D11 match i want to add cells E5 and E11 if not i want to aggregate them so in this case i would like the final output to look something like this --


EUR/USD S 6,000,000 USD 1.35237

in the end i want the final output in a different sheet but using the same format from column A to G.

Thanks

[AB33]

Did you mean rows 2 and 5, not 11? Rows 2 and 5 match.
You can 2 to 3 columns match for comparison purpose.

[SoulPrisoner]

Hi Maulik1k,

comparing multiple cells is not an issue, just your example kinda lacks the clear statement what you´re trying to achieve (at least to me), from what I´ve seen in your file it seems to me you´re trying to make pairs for forex clearing or whatever market you´re trading on and therefore it seems to me you´ve declared it wrong you are not looking for match in col D but for buy/sell combination (at least that makes sense to me from what I´ve seen within the file) but I have still not made out the result you´ve gave, cause in the case I´m describing you´ll end up with 7Mio remaining on lane 11 not 6 as you´re proposing.

also you need to set the acceptable difference in rates to make a pair or ignore the match etc.

Hope to see more clarification in oder to actualy help you out...;-)

best regards

Soul