Hi to All,

Need to separate a Sheet into multiple Sheets base on Column criteria.
I have created a code via macro recording, i don't know how shorten my code.
Since i have to separate the sheet in a specified column. If i have 35 criteria i just copy the the record code 35 times (troublesome).

Here have attached the code i did.

Please somebody help me for this.
Final Schenker SOA Germany for waste.txt