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.

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

If you know only one record contains the word pneumonia and you want a
formula to do this, you can use wildcards in your forumula criteria.
For example, if you're using match of vlookup then you could write:
=match("*pneumonia*",range,0)
=vlookup("*pneumonia*",range,column,false)

* = any characters of unlimited length
? = any one character


--
BlueDaze


------------------------------------------------------------------------
BlueDaze's Profile: http://www.excelforum.com/member.php...o&userid=27465
View this thread: http://www.excelforum.com/showthread...hreadid=569560

The issue with this is that it is not going to be the only word in that cell so I cant sort by this or autofilter. I need something that will select it out of a list in that one cell, there may be two or three different things in that cell.I was thinking "*pneumonia*", or something like that.

AM I missing somethign here? The Custom filter I described earlier using the
'contains' feature will look for parts of a cell. It will find all cells in
that column that contain the word you look for(even if it contains more than
"pneumonia"), and display the entire row for the matching cells. So if you
want to just move the appropriate rows over one time ( or even a few), that
is a simple procedure to do it.

BlueDaze provided a procedure that will also work, but it requires you to
use a formula. This would be better if you wanted to have this happen more
autmatically, where you would be doing ti more freqently.

if we are missing the point, please provide the info in a different manner.

"shadesofsisyphus" wrote:


The issue with this is that it is not going to be the only word in that
cell so I cant sort by this or autofilter. I need something that will
select it out of a list in that one cell, there may be two or three
different things in that cell.I was thinking "*pneumonia*", or
something like that.


BlueDaze Wrote:
If you know only one record contains the word pneumonia and you want a
formula to do this, you can use wildcards in your forumula criteria.
For example, if you're using match of vlookup then you could write:
=match("*pneumonia*",range,0)
=vlookup("*pneumonia*",range,column,false)

* = any characters of unlimited length
? = any one character


--
BlueDaze


------------------------------------------------------------------------
BlueDaze's Profile:
http://www.excelforum.com/member.php...o&userid=27465
View this thread:
http://www.excelforum.com/showthread...hreadid=569560




--
shadesofsisyphus