Pleae help me to extract the particular data's

[sampath]

Hello,

I have attached the example of document. In first sheet we have lot of data's and I need to extract the particular data(VS3041*** etc) and these extracted data's to be saved in next sheet as i attached examples.

Kindly assist me for this which is very helpful for my process simplification.

Thanks & Regards,
Sampath.S

 

[Lakshmi Narain]

Hello,

I have attached the example of document. In first sheet we have lot of data's and I need to extract the particular data(VS3041*** etc) and these extracted data's to be saved in next sheet as i attached examples.

Kindly assist me for this which is very helpful for my process simplification.

Thanks & Regards,
Sampath.S

In your data VS3041 is available in different cell and in some middle of cell also.
is that right.

 

[sampath]

Hello Narain,

Your mentioned point is right. I need only extract the VS3041 and after data's.

Needed out examples are available in Output sheet in attached one.

Kindly assist me.

Thanks for your reply.

Regards,
Sampath.S

 

[Lakshmi Narain]

Hello Narain,

Your mentioned point is right. I need only extract the VS3041 and after data's.

Needed out examples are available in Output sheet in attached one.

Kindly assist me.

Thanks for your reply.

Regards,
Sampath.S

I guess its complicated. And Is this your actual data that you getting.

 

[Lakshmi Narain]

I guess its complicated. And Is this your actual data that you getting.

Please check the file is it okay.

 

[sampath]

Thanks for your help.

It's working fine. but put more effort for large datas.

Thanks for your assistance.

 

[Lakshmi Narain]

Thanks for your help.

It's working fine. but put more effort for large datas.

Thanks for your assistance.

Dear Sampath
That's Why I asked for actual Raw dump if i see it i can get any idea.