Macro for allocations and movement

[Howza297]

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

 

[patel45]

what do you mean for exact opposite ?

 

[HaHoBe]

Hi, patel45,

if cell value of Q2 is 2, then search for -2 - it´s as easy as that.

Ciao,
Holger