fayez_MrExcel
Active Member
- Joined
- Oct 29, 2005
- Messages
- 439
- Office Version
- 365
- Platform
- Windows
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
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sort by date range & nationality
- Thread starter fayez_MrExcel
- Start date
cpg84
Active Member
- Joined
- Jul 16, 2007
- Messages
- 264
- Platform
- Windows
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.
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.
Upvote
0
Similar threads
- Solved
- Question
