Desire data extract from the sheet “input” to the sheet “output”

Hi xladept, sorry for late response, thanks for your intention to help me. According my input data range It is almost correct output. but If I keep single individual data format (please see six example data format as attached) it is not giving the desire output .

Hi xladept, Thanks for your valuable time , still I am not getting any output results , its showing error message like below.

Run-time error '424'
object required

Hi jindon, thanks for your helping mind. I have tested all my six different input data format , yes all output is correct except below data format (as attached) . I need your support for this to complete my task .that will help me a lots , thanks.

Can you explain how do you find it should go under REMARKS?

I can not find any good reason...

Hi xladept, Thanks for your concern regarding my issue again. yes i am using same input as i had in my first post (as attached file name "NODE"). there have six different data format. if i use all six data format together then i get the output 100% right , but if i try to use individual single data format it was not giving any output(by your first macro).
however if i use your 2nd macro i did not get any output results just getting error as i said before in the post (all together or singly what ever its input data). hope got my point.

Hi jindon,
If any Mobile number (like MSISDN 8801687347784 ) , its all data are ok but it is “MS PURGED IN VLR” . From here I can understand that this mobile subscriber having no problem in his data profile but this Subscriber Is not using his mobile number for long days , that is why in our system (subscriber data sever) tells us as technical language “MS PURGED IN VLR” . It is not mandatory “ MS PURGED IN VLR” will be under REMARKS field . you can give any condition like if macro gets “MS PURGED IN VLR” in any particular field , then it will be showing just “PURGED” in the REMARKS field along the other data. So that I can understand the subscribers having no problem in his data profile , now I will just tell the subscriber to pull out the mobile SIM from Mobile & reinsert the SIM . to get the service again . hope got my point . sorry for my bad English competence

So, if it finds "MS PURGED IN VLR" in any line, it goes to REMARKS?

Then add one line just before "Next"

Please Login or Register  to view this content.

Hi jindon , its really outstanding job for me . I can’t explain how much it will help me. Now I will be able to make my report within moments , where previously I would took manually that was very time consuming & boring job. Its awesome !! thanks a lots for your valuable time in this regard for me .

Very good and thanks for the feed back.

Hi xladept , sorry for late response. Yes now it works perfectly. thanks for your time..