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!
Bookmarks