MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
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!!