In this case, I want to search a column to find a specific parameter, the word pneumonia, and use the entire row where that parameter is found to populate a new spreadsheet. I have about 900 rows to search this way so how could I do this? I was planning on using a Userform, but if there is an easier way that would be great too.