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:
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.