Hi,
Apologies, new to VBA, I have spent nearly the entire day pulling my hair out because of this coding.
I am trying to code so that it will look for "ERROR" in the whole workbook, in all sheets this is located in column G, then copy the rows where it is found into a worksheet titled.. 'ERROR'. Ignoring all rows where the text isn't found.
I had some moderate sucess writing an incredibly long formula, but I am sure there must be some VBA.
Man
Bookmarks