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
Bookmarks