Split the file by drawing number

[sanju2323]

Dear Expert,
I am trying to Split the file by drawing number.
Drawing number in an unique word is hidden, you will know by observing. It is to divide the sheet from this unique word base.
I am weak in VBA, Please help me, I will be very grateful to you.

Thank you in advance

[karedog]

Maybe :

Please Login or Register  to view this content.

[sanju2323]

karedog,
Thank you very much for giving the code but it is not working on other files. I have attached more samples Please see the attachment file.

[jindon]

Try

Please Login or Register  to view this content.

[sanju2323]

jindon
Thank you so much sir, your code is working very well.

[sanju2323]

Hi jindon,
Can it be create in a new workbook?

[jindon]

Change to

Please Login or Register  to view this content.

[sanju2323]

Hi jindon,
I am sorry that I could not understand you properly, I have to export data only in single workbook but in different sheets.
Please see the attachment file for you to understand properly.

[jindon]

Change the code and save it as .xlsm first then run.

Please Login or Register  to view this content.

[karedog]

Just change this line :

Please Login or Register  to view this content.

to :

Please Login or Register  to view this content.

[sanju2323]

jindon, Thanks so much sir code are working very well.

[sanju2323]

karedog, Thanks so much sir

[karedog]

You are welcome, thanks for the rep.points, and don't forget to mark this thread as solved.

Regards