Auto Sort Table

[batchy]

Hi,

I have created a table which is populated from using an index lookup.

I've created some VB which should auto sort the table based on % but doesnt seem to work.

Attached is a copy.

Kind Regards

Chris

[patel45]

I think you have to do all operations by macro without using formulas

[batchy]

So could hard code the results and then have the auto sort run?

[foundy]

Hi,

in K7 put:

Please Login or Register  to view this content.

In L7 put:

Please Login or Register  to view this content.

If you drag these down the length of the table this should give you a sorted WTD column

I used this formula to aid in a football league table.

Hope it helps.

[batchy]

Can you explain why the

Please Login or Register  to view this content.

uses $c$6?

[foundy]

C6 is a reference point above the site names. The match part looks down the ranking to find out how many rows down from the reference point the formula should look.

Does that help?