sort by date range & nationality

[fayez_MrExcel]

how can i sort the database from sheet1 with a criteria of FROM and TO Dates (date range) AND nationality. sheet2 will serve as the sorting area..thanks

 

[cpg84]

I have done this on my spreadsheet for scores, wins/losses, percentage etc. which are taken from different sheets then put all together on the main sheet.

How you should do it: make a table at the bottom of sheet 1 with all the info you have. Then on sheet 2, make another table and link the data from sheet 1. That way you can make, what I call, a super table, which can have heaps of other data linked from other sheets. It is pretty sweet once it is all done. Then you just use the sort button to sort it.