I need a VB code to open an exisitng excel file and sort a column and store in diff excel sheet.eg i have a column data A,B,C,D,E.the code should sort all the A in the column and store in new excel sheet..as like all B,C,D,E should be stored in diff excel sheet....................

ANY WHO KNOWS pls HELP ME ...............

Use the macro recording feature of Excel; you can find it yourself :-)

thanks yello but i have tried that before but sorting is perfect but when copying in to new excel the program is not recording for that .............so if u have code for whole project pls send me