I am trying to condense a 32,000 student database based on the the street names. In valid street names come across lower case. I have written a marco to find them, bold them and change the font color; but I don't know how to write a macro to copy the row this relates to into a new worksheet. I am a beginner, can anyone offer some advice I would greatly appreciate it.

Rheia