+ Reply to Thread
Results 1 to 2 of 2

Find and copies cells with same keywords or starting word.

  1. #1
    Registered User
    Join Date
    10-07-2012
    Location
    MORADABAD,INDIA
    MS-Off Ver
    EXCEL 2003
    Posts
    2

    Find and copies cells with same keywords or starting word.

    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
    Last edited by SHARIB; 10-07-2012 at 03:22 AM.

  2. #2
    Forum Contributor
    Join Date
    10-02-2012
    Location
    Bumi Nusantara
    MS-Off Ver
    Excel 2010; Excel 2016
    Posts
    136

    Re: Find and copies cells with same keywords or starting word.

    please turn off your Caps Lock
    or it just like you yelling to some one

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1