I'm trying to make a code that will search in row 11 of a spreadsheet until it find a specific cell that will be written with the word "ok". Once this cell is found, the macro should copy and paste a value in a certain range of this column. from line 50 to 586 of this column.
I am not very familiar with VBA but I would be very grateful for your help.
Many thanks in advance!!