i assume i would need multiple loops but Im a newb lol
highlighted are the pairs of offsetting positions (the different colors indicate the offsetting pairs)
how do i know they're offsetting?
1) one has a"C" in column E, the other is BLANK
2) one is "B", the other is "S" in column D ("bought/sold" indicator)
3) they'll have OPPOSITE SIGNS (one positive, the other negative) in column A ("bought/sold AMT")
4) they'll have the same TAG code in column H
the other challenge is that these offesets won't always be next to each other; one could be in row 2 and the other could be in row 100.
then I'd like the code to CUT and paste these offsetting positions to another sheet ..i want it to be CUT so that they're no longer in the original sheet as they're cancelled positions
highlighted are the pairs of offsetting positions (the different colors indicate the offsetting pairs)
how do i know they're offsetting?
1) one has a"C" in column E, the other is BLANK
2) one is "B", the other is "S" in column D ("bought/sold" indicator)
3) they'll have OPPOSITE SIGNS (one positive, the other negative) in column A ("bought/sold AMT")
4) they'll have the same TAG code in column H
the other challenge is that these offesets won't always be next to each other; one could be in row 2 and the other could be in row 100.
then I'd like the code to CUT and paste these offsetting positions to another sheet ..i want it to be CUT so that they're no longer in the original sheet as they're cancelled positions
