How about creating a filter? Data/Filter/Autofilter. Select the arrow above
the column that contains Pneumonia. Select Custom in the drop dowm. In the
box that appears, select Contains in the first drop down and type
"Pneumonia" in the box at the right of it. Click OK.

You have just filtered the sheet for the rows containing pnuemonia.
Highlight them, Copy. Then pastee them in your new sheet.

Hope this helps.

"shadesofsisyphus" wrote:


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.




--
shadesofsisyphus