Copying data if it matches criteria

[yuckysocks]

Hi there, I can't seem to figure out what functions to use to accomplish this effect.

One workbook sheet is a two column roster of names. Column one is "names" and column two is "medical needs?". Column two won't be filled in for every name.

I can say in English "when column two has text in it, copy that whole row to another sheet that summarizes all students with medical needs". What I can't do is say that in Excel code.

I want to pull out all rows of data where there is -anything- present in column #2, and paste those into a table on another sheet.

How can this be accomplished?

Thanks!

Alex

[sweep]

Hi,

Try this:

Please Login or Register  to view this content.