Create multiple *xls files

  • I have some *xls file. I need to run though the file & for each item in "manuf" column to create an *xls with its name and rellevant rows.


    I will try to show the sample:


    number manuf pn
    -------- ------ ------
    ABC12345 AVX 45623
    ABC12346 AVX 89746
    ABC12347 YAGEO 11898
    ABC12348 YAGEO 35659
    ABC12349 KEMET 98752
    ABC12350 KEMET 65656


    this file will create 3 files:
    1. AVX.xls (will contain two first rows)
    2. YAGEO.xls (will contain two second rows)
    3. KEMET.xls (will contain two third rows)


    May someone to assist me?


    Thanks

  • Re: Create multiple *xls files


    I havent had much time to make this efficient, but it should work... you should be able to adapt it to suit your needs....



    HTH... I'm off to bed in any case.


    Ger

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!