Using a current spreadsheet to populate a new one

  • Thread starter shadesofsisyphus
  • Start date
S

shadesofsisyphus

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 i
found to populate a new spreadsheet. I have about 900 rows to searc
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
 
W

Wiley

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.
 
B

BlueDaze

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
 
S

shadesofsisyphus

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

Wiley

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.
 
Top