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: 6
Default help with sorting data in excel(Macro)

i want to sort data

it is inthe format where i would like to have 3 rows considerd as 1
unit and depending on the highest value in one column they must be
sorted the three rows in itself as well as the entire three sets

an example

col a b c
12345
1 2 3
4 5 6
7 8 9


24567
4 6 4
and it continues
in set of three(rows) in col a b and c


and i am interested in sorting in EXCEL by say column c and want all
three values to be displayed infront of the 12345 no that is the first
row that is empty after the col value.

also once i have sorted the values, i want to make a different sheet
which has all the max values in each row set and sort them too

please can anybody help me with the same

 
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
Formula or macro needed for sorting complex data issue. malycom Excel Discussion (Misc queries) 4 November 27th 08 07:24 AM
Macro for sorting color data Tufail Excel Programming 2 July 4th 06 01:06 PM
Data sorting macro Y. Belenky Excel Programming 2 December 28th 03 08:27 PM
Help with data sorting - macro? rine9558 Excel Programming 5 November 11th 03 02:28 AM
Please Help with Excel Sorting Macro!! ticketopia Excel Programming 1 October 6th 03 02:57 PM


All times are GMT +1. The time now is 04:42 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"