I've been searching for a code to handle the following, but can't seem to find the right one.
Find the "ERROR" string in column A of Sheet1,
Copy its string value in column C (J1.G0203 for example)
Paste it in col/row A2 of Sheet 2.
Loop until all ERROR string values are...