Member Avatar for laxman_project

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 ...............

  • 2 Contributors
  • 2 Replies
  • 86 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by laxman_project
Member Avatar for yello

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

Member Avatar for laxman_project

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.