Creating a Table

[jwgreen1986]

Wonder if anyone can help me. I am wanting to create a league table based on peoples sales. I am planning on separating the sales team into two worksheets. one for used one for new. the format below is what i will have on each worksheet. what i want to do is then create a separate worksheet with some drop downs on. the drop downs will have each of the month on. when the month is selected it will show a league table of the sales people with their sales for that month on it. sorted obviously so the person with the most is at the top.

how difficult is this to produce. i am more than happy to get the information i need into one organised spreadsheet. my issue is the creation of the drop downs and then it showing the correct information based on it. Also will i need to take into consideration if there are new starters. how would i make sure that drop downs will include new sales people in the tables. similarly i will need to hide, remove people if they have left (by their end date). so from below people like Bobby would only appear on the Jan table as he left the end of Jan, Emma wouldnt be on the Jan table because she didnt start till feb. and so on.

User ID	Name	Site	Scheme	Start Date	End Date	YTD Sales	Jan	Feb	Mar	Apr	Jun	Jul	Aug	Sep	Oct	Nov
123	bobby	luton	New	01/03/2018	31/01/2019	17	17	0	0	0	0
465	James	Oldham	Combined	10/02/2016		26	10	7	3	4	2
546	Linda	Derby	New	12/12/2012		14	7	3	0	3	1
468	Emma	Liverpool	New	01/02/2019		17	0	8	5	2	2
454	Carl	Stoke	Combined	12/06/2017	25/03/2019	9	0	4	4	0	0
987	Mel	Manchester	New	10/07/2017		31	11	10	8	1	2

<tbody>
</tbody>