Hi there and thanks for your time and help with my problem.
I am trying to find the best way to automatically copy and paste an entire row to a new spreadsheet if the text in one of the columns meets a certain criteria.
To further complicate the process, I have identically formated lists...