Can someone write a VBA code for this? I would like to search for something like "COMCAST" in column "A" of sheet 1 and have those rows appear in sheet 2. On the next search clear sheet 2 and copy the new search data over to sheet 2. I hope this makes sense.

Sample file is attached.

Also, how do you mark a post as "SOLVED"? I look everywhere and can't find how to do it. Thanks everyone who responds.

Attached Files

Totals.xlsx (35.5 KB, 14 views)