Help with leaderboards

Hi all I need help and I have tried racking my brains and google, found a vba code but cant quite suss it.

Here is what I want to do,

I have data transferring from other sheets that I want into quarters league table then also a yearly one. as you can see I have set this up, but what I cannot figure is how to sort them all so the highest sales per person is at the top and highlighted in colour, is this possible can anyone help me please?help.JPG

.
Presuming your data will always lie within H21:H29, this macro will do the job for you :

Please Login or Register  to view this content.

The above requires a CommandButton attached to the macro to run it.

If you paste the macro code into the Sheet Level Module, it will to the sort automatically whenever something changes in the range H21:29

Please Login or Register  to view this content.

Hi there. I also want the quarters sorting as going to give a prize for winners in quarter and then a prize for yearly winner if that makes sense. The data will always be in them colomuns. I only like spaces as I don't like it all crammed together.

My sincere apologies it will not allow me to post inks

Also posted here excelguru.ca/forums/showthread.php?8903-Help-tables-sorting&p=36597#post36597

Hi Marvin, If I merge cells so can make it bigger and still pretty would that work as a table, I have no idea what a pivot table is. I only Need Name and link deals sold, then whoever has highest sales in quarter 1,2,3,4 and the yearly total to be at the top preferably highlighted with colour.

Had to remove links as wouldn't allow me to post.

Originally Posted by MarvinP

Hi mercy,

I'm a little sad at your comment of:

If you had only three columns of Name, Date and Sold; you could do a great looking Pivot Table that could do all you work for you. (No formulas needed!!)



BUT - if your data isn't in a table (no blank columns in the table) you can't do the above.

Don't worry, we have lots of people who refuse to structure their data to be more efficient and use the tools built into Excel. I call those worksheets "Pretty" but not "Efficient". You will only go so far in using the power of excel if you refuse to use "Tables".