automatically sorting values ina range

A

Andy Sandford

Hi all

My problem is this... 8o0

I need to sort the information contained within a hidden table (4 rows by 8
columns) and display the results in a second table that is visible.

The sort is based on numerical values (descending) in the 8th column of the
hidden table - the results of the sort need to be refined further by values
in the 7th column if those in the 8th column are equal.

But... I need the display table to rearrange itself automatically as the
values in the hidden table change.

In short, I need it to work exactly as the sort button on the toolbar - but
without my intervention!

In case you're wondering, it's to sort a football league table as the
results of the matches come in.

Thanks in advance

Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top