Sorting data

[t.holmes]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I've set up a spreadsheet, where the data requires a sort - which is fine, i've done this many times.

However this spreadsheet will be updated and added to over a long period of time, is it possible to apply a sort and it update the order of the data as it is input?

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I've set up a spreadsheet, where the data requires a sort - which is fine,
i've done this many times.

However this spreadsheet will be updated and added to over a long period of
time, is it possible to apply a sort and it update the order of the data as
it is input?

That would require an event macro, and macros have been disabled in
Office 08, so no.

 

[t.holmes]

I was hoping there would be a way around it, thanks for your reply