Hi Guys,
I have been puzzling over trying to create a macro for this. I am pretty new to VBA, and so this is probably out of my league in terms of programming
I need a looping macro to take the first value from Q (i.e Q2), then search down the other values in column Q for its opposite value (so that the net is exactly nil). If the exact opposite is found, i need the macro to cut both rows that these cells sit on, and paste them to another sheet called "allocations" underneath eachother. If it does not find a match in column Q, then move onto the next value (i.e Q3)
Thanks in advance to any help that anyone can give me, I will truely appreciate it
I have been puzzling over trying to create a macro for this. I am pretty new to VBA, and so this is probably out of my league in terms of programming

I need a looping macro to take the first value from Q (i.e Q2), then search down the other values in column Q for its opposite value (so that the net is exactly nil). If the exact opposite is found, i need the macro to cut both rows that these cells sit on, and paste them to another sheet called "allocations" underneath eachother. If it does not find a match in column Q, then move onto the next value (i.e Q3)
Thanks in advance to any help that anyone can give me, I will truely appreciate it
