How to set an offset value in a range

[Speedy1]

I'm trying to copy data from column B to column AO if column C meets a condition. My problem is I don't know how to set the result value. (non-programmer)

Please Login or Register  to view this content.

Thank you in advance.

[carrob]

Is this what you're looking for? Not much different from what you had:

Please Login or Register  to view this content.

[nilem]

or

Please Login or Register  to view this content.