Create different text files from parts of a range

[shayshay]

Hi,
I need to export a text file every time a value change from an excel range, example:

AAA 01/01/16 100.52 5001
AAA 01/01/16 536.13 8001
AAA 02/02/16 804.55 4561
BBB 05/01/16 400.11 7120
BBB 06/07/16 913.40 8124

the output needs to be 2 files:
1St file: AAA.txt
AAA 01/01/16 100.52 5001
AAA 01/01/16 536.13 8001
AAA 02/02/16 804.55 4561

2nd file: BBB.txt
BBB 05/01/16 400.11 7120
BBB 06/07/16 913.40 8124

i have try loops .. but still couldn't get it..

Thnx

 

[Hui]

Shayshay

Firstly, Welcome to the Chandoo.org Forums

You could use the techniques described below and adjust the output to save the data as appropriately named files:

Move Data to other Sheets
http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/
Advanced Filter Move Data to other Files
http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/