Excel extractor

Discussion in 'Software' started by meetguru, Dec 16, 2012.

  1. meetguru

    meetguru Private E-2

    Hi friends,

    I need a script for the following:

    I Have one excel sheet with more than 30000 rows

    each row has first column containing different product code and other columns contain that products other data.

    same product code might have repeated in any row and for any number of rows.

    I want to generate separate excel file for each product code.
    output file name should be product1.xls product2.xls and so on..

    where product1, product2...... are respective product codes

    ( i can use a folder for this purpose.)

    Please guide me ..
    :)
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds