How do I automatically re-sort a column?

[6626ben]

Version: 2008 I have a spreadsheet with 3 columns, The first two columns are 'Rank' and 'Team', and the third is 'Points' I would like to find a way for the data to re-sort itself when I alter the data in the third column. At the moment I am having to do it manually but there must be a way for it to automatically change when the data is altered. Please help!
Ben

 

[John_McGhie_[MVP]]

Hi Ben:

You can't do that in Excel 2008: that requires VBA, which you don't have.

Sorry: Next version.

Version: 2008 I have a spreadsheet with 3 columns, The first two columns are
'Rank' and 'Team', and the third is 'Points' I would like to find a way for
the data to re-sort itself when I alter the data in the third column. At the
moment I am having to do it manually but there must be a way for it to
automatically change when the data is altered. Please help!
Ben

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[CyberTaz]

.... But be careful what you wish for - you just might get it. Depending on
the length of the list, can you imagine how your workflow would be hampered
if the list resorted itself every time you enter/change a value in the key
column? Even programs that do have an auto-indexing feature usually don't do
the sort every time a key value is changed or a new record is added. It
isn't done until the table is next accessed or the table is refreshed.

IMO it's far more efficient to add/edit the records in any given session,
click in the key column (especially since it sounds as though you have only
the one sort key) then click either the A-Z or Z-A button to sort the
records based on the newly added data. If you want it 'quicker' than that
you can assign keystrokes to the sort commands... Even with a macro you'd
still have to do something to run it so why not just run the Sort instead?

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[6626ben]

Thank you guys