Skip to empty row or Creating a log

Hi,
I have "live" data constantly updating some cells from VB program. When certain conditions are met I want to capture values from lets say 3 different cells and put them in one row. When another condition is met I want to the same thing but to put the values on to the next row and so on. Basically creating a log. The number of rows has to be pretty long. Conditions are pretty much easy "if A1=A2..." I could easily do that from VB program but I really need it to be done within excel. I think there has to be a very easy quick solution, but I can't think of one, because my excel skills are weak.
Thanks !

Not sure I understands you problem but this macro

Please Login or Register  to view this content.

will copy a range and place the first result in range K2:M2 (row 2), the next time you run it result will be placed in range K3:M3 and so forth.

Alf