Move cells based on their values [Closed]

Report
Posts
1
Registration date
Saturday March 25, 2017
Status
Member
Last seen
March 25, 2017
-
Hi, I did this a few years ago once but I can't remember how I got it to work.

I have 2 sheets named BOQ and V.O.
The BOQ sheet has a list of items with quantities, and a rate to each item. The quantities, has two vallues: tendered Qty, and installed to date Qty.
What I want to do is, as soon as the installed to date Qty exceed the tendered Qty, the row with the item description, as well as the difference between tendered Qty and installed Qty must be carried over to the V.O sheet.

I've currently have a formula in my V.O description cell:

=If(BOQ!G5>BOQ!D5;BOQ!B5;0)

Now the vallues carry over correctly, but in the same row number as the BOQ sheet. I want it to auto fill after one another on the VO sheet.

Please help!