Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 14th, 2010, 11:40 AM
Registered User
 
Join Date: Dec 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help with a sorting Macro

Hello, I'm new to VBA and I've got some problem with a macro, here's my problem:

I got 6 columns with 204 rows each with on the top the average value of the column

What i need to do is to sort the 6 column in descending order regarding their average value, ( so replace the first column with the value of the best one and so on ) what can I do ?

I've already tryed to follow the steps here Sorting Cells using VBA but it's not my case and I'm very bad in VBA programming..

I'll try to wxplain better my problem with an example, I got this data:

2 4 1 5 25 18

1 5 4 3.8 15 17
8 15 12 7 1 2.3
12 2 2 8 5 6

in which on the top I've got hte average value of the column and in the column all the data, I need to sort first the row with the average value, than give them a rank ( without lost of any information regarding their corresponding column ) then sort the column regarding the new rank

I know that might seems really difficult, but please can someone halp me ?

any comments will be gladly accepted

Thanks in advance !

Last edited by stefano; December 15th, 2010 at 06:22 AM..





Similar Threads
Thread Thread Starter Forum Replies Last Post
calling to xlam macro from macro inside xlsb SteveB Excel VBA 0 June 30th, 2008 06:43 PM
Macro excel mathb79 Excel VBA 3 August 13th, 2005 06:55 PM
Datagrid sorting by non alphabetical sorting? LLAndy VS.NET 2002/2003 1 July 15th, 2004 01:20 AM
Macro Help! Jolin VB How-To 0 April 22nd, 2004 08:38 AM
Macro KennethMungwira Access 1 June 13th, 2003 12:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.