Forum Discussion
filtering OUT positions loop (Vba)
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 offs...
correct, given that the matching TAG has the opposite signs of numbers in either column A or C
AND
one has blank in column E,the other has "C" in the same column (ie column E)
AND
one has blank in column E,the other has "C" in the same column (ie column E)
The code in the attached file copies the pairs of offsetting positions with matching TAG code to sheet2 if there are opposite signs in column A and if there is either "C" or "" in column E. These positions are removed from sheet1.