Copying Value if other cell value is "ok"

[axisambrosia]

Hi there,

I am currently stuck at some basic vba stuff. I am trying to copy values from column K of sheet 1 to column A in sheet 2, if column A (sheet 1) has the value "ok".

A try to visualize my problem:

Sheet 1 (dots are space)

• Work 1 | work 2 | Number
• .."ok"...|...........|.234412
• .."ok"...|...........|.234416
• .........|...."ok"...|.234418

where Work 1 = A ; Work 2 = B ; Number = K

After I use the macro, Sheet 2 should look like this

• Work 1 | work 2
• .234412|234418|.
• .234416|...........|
• ...........|..........|

I am currently using this macro, but it won't work
The list starts at row 16

Please Login or Register  to view this content.

I hope you can help me with that, I really don't know what to do

[AB33]

Axis,
I am not sure, but try it anyway

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Another option. Untested, try on a copy first.

Please Login or Register  to view this content.