My name is Brandon I'm new to the forum and am thrilled to have found a community that specializes in excel. The current issue I'm having is I'm looking to copy entire rows containing a specific keyword (in this case - emergency). I have attached a screenshot so you can see what I'm referring to. I think I might be "finding" these values in such a way where it's not allowing me to copy full rows.
I cannot select whole rows at a time using my current method. The way I'm currently "finding" is Ctrl + F, and then I select find all, select the whole list, close out of there
and then using an excel add on "kutools" to copy ranges.
When it functions properly I'm able to copy and paste the multiple ranges into a new cell, however it's just copying the keyword that I searched not the rest of the data in the row which is what I need of course. I have learned a little about conditional formatting from the forum but it seems based on what I'm reading it might be the way to achieve what it is I'm looking to accomplish. I appreciate your help in advance
