Hi all !

First, I would like to say I'm a VBA novice, I'm not a programmer. I really don't know how to do the following question:

I have a large CSV file, in alphabetical order, with hundreds (maybe thousands) of lines (for example, a catalog from a shoes shop). I need to import this file to Excel and every time the name of each manufacturer changes (the first column in CSV file), a new sheet must be created and the name "SheetX" (Sheet1, Sheet2, etc...) must be renamed with the name of the manufacturer. How can I do this using a VBA Macro ? Please, help me !

It's something like:
  • Read the first line;
  • Rename Sheet1 to manufacturer's name;
  • Fill the cells with all content from the manufacturer's name;
  • When read a new manufacturer's name:
  • Rename Sheet2 to manufacturer's name;
  • Fill the cells with all content from the manufacturer's name;
  • repeat until EOF.


Please, help me !
Thanks a lot !!

Demian.