HELLO,
I need A MACRO with details as under:
I have an excel worksheet in which i have names of defendants and plaintiffs written as under:
Plaintiff - JERRY SPRADLING
Defendant - JOANNE PERRY
Defendant - HEATHER PERRY
Defendant - MICHAEL PERRY
Plaintiff - JUSTIN TSCHAGGENY
Represented by: JAMES H DEANS
Plaintiff - SHARLA TSCHAGGENY
Represented by: JAMES H DEANS
Defendant - BRANDON LUJAN
Defendant - TIFFANY LUJAN
I need a macro which finds and copies only the defendants names and paste in cells range which i describe like from cell A1 to cell A10.
Also to add that the count of defendant names varies from one to six on different worksheets, like i have five defendant names in this worksheet but sometimes i have only two names.
Please help me
Bookmarks