+ Reply to Thread
Results 1 to 3 of 3

check each cell for certain condition, copy the content in a new worksheet

  1. #1
    Registered User
    Join Date
    03-31-2012
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    9

    check each cell for certain condition, copy the content in a new worksheet

    I need to loop through the worksheet and check for the content in each column. If it meets the criteria then I need to copy it to another column in another worksheet. and I need to add an 'alt enter' after the content in the same field so I can continue with adding the rest of the content in the same column without mixing with my previous content.

    The rule should be as following:
    -First blank column of the row -> stop checking and move to next row for checking
    -First column with consists of word "name ". no action required but it needs to move on to the next column for checking.
    -For column not blank, not consists of word "name " ->copy the content to a new worksheet add an "Alt Enter" after the content. Then continue to the next column checking, need to copy the content and add it into the same column in the new worksheet with 'alt enter' after it as long as the content in first worksheet fulfil the criteria of field not blank and not consist of word "name ".
    -For subsequent blank field in the row, stop the checking and move to a new row. but we need to keep the previous copied content in the new worksheet.
    -This checking shall continue to each column the go the next row and it is apply to the entire worksheet

    Please refer to my sample excel worksheet for better understanding.


    Advance thank you for everyone who offer their helps.Thanks again!
    Attached Files Attached Files

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: check each cell for certain condition, copy the content in a new worksheet

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-31-2012
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: check each cell for certain condition, copy the content in a new worksheet

    Thanks Nilem,

    You are great, the code is working good. Thank you very much. A big thumbs up for you.

+ 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