LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Sorting Multiple Columns in a single operation?

We have collected approx 100 pieces of info on 250 students, each held
student id being the column header and the data held in that column. We want
to be able to select all the data and to be able to sort each column into
ascending or descending order, independently of the other columns in a single
opeation. (i.e. the equivalent of selecting each column of data, sorting it,
then selecting the next etc., until all hav been slected and sorted). Can
anyone suggest how this may be done, is there a VBA script out there that can
do this?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple columns into single row Mr. R Excel Discussion (Misc queries) 3 January 12th 10 11:32 PM
move multiple columns into single set of columns mrg9999 Excel Discussion (Misc queries) 1 September 25th 07 05:08 AM
removing single quotes from a paste operation joeycalisay Excel Programming 7 February 9th 07 02:39 AM
SUMIF with multiple criteria for multiple columns to sum a single SavageMind Excel Programming 1 July 27th 05 03:34 PM
How do I lock columns together in a single row for sorting purpos. S.J.Michael Excel Discussion (Misc queries) 1 April 26th 05 02:18 AM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"