copy cells by criteria

[ccsmith]

I would need a macro where it would copy some cells into a new range by a given criteria.
I also attached a sample file where you can see more clearly the situation.

If value from column K is greater than 0 it can copy some cells from the same row where the criteria was right to a new range (O30:V100).

I tried to use the following forumula without the required result:
"[O30:O100] = [IF(K2:K1000>0,A2:A1000,"")]"

[snb]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[ccsmith]

Thank you for the solution. It is working.