Hello,
I have the code below that copies a cell that contains 'ERROR" from Sheet 'Filename" to cell K2 to sheet "Email". I am running into an issue when there are multiple 'ERROR' on the page. It just copies over each other in K2. I think an offset is needed, but have run out of ideas on how...