I want to create a table which collects data from a certin cells in me
worksheet, after collecting the data. i want the table to autosort it
self by some categories.

same principle as they did the mondial file:

http://38.113.149.34/MONDIAL.xls


I just don't understand what forumla in which they used that make the
table sort itself.

if anyone can give me a brief explanation,I'd really appreciate it.