jwgreen1986
Board Regular
- Joined
- Mar 8, 2019
- Messages
- 64
i am wanting to create quite a complex league table within a spreadsheet i have. The first part is that i want the user to be able to select which league table they want to show. i am planning on having 2 drop downs. the first drop down will contain two options. New and Used. once the user has selected one of these then they can then select from the second drop down. This will contain the months Jan-Dec. I may include a quarter drop down eventually but this is not important for now.
now that the drop downs are explained i will go in to the information that will be shown. i have one master spreadsheet that contains every sale made by a certain department. i need to create a league table based on this information. it has a user ID so i can easily get a certain users other information i need. however i am having a little trouble with certain things.
1 - certain staff can sell new and sold items. these are known as combined. so when creating the table i need to be able to separate their new sales and used sales so they can go into the different respective tables.
2 - i have a sold date column. so this can be used to know the difference between months. it is in dd/mm/yyyy format.
so to conclude i need to create some league tables. the ones shown are dependant on what the user selects from the drop downs.
what is the best way to approach this? is there a way that it will just automatically update a league table based on the drop downs? how do i define the criteria needed for each of the selections in the drop downs? will i need to create a league table for each of the values in the drop downs? so 12 for new and 12 for used?
once i get the league table up and running it shouldnt be too difficult pulling in the information i need. probably a case of doing a vlookup.
now that the drop downs are explained i will go in to the information that will be shown. i have one master spreadsheet that contains every sale made by a certain department. i need to create a league table based on this information. it has a user ID so i can easily get a certain users other information i need. however i am having a little trouble with certain things.
1 - certain staff can sell new and sold items. these are known as combined. so when creating the table i need to be able to separate their new sales and used sales so they can go into the different respective tables.
2 - i have a sold date column. so this can be used to know the difference between months. it is in dd/mm/yyyy format.
so to conclude i need to create some league tables. the ones shown are dependant on what the user selects from the drop downs.
what is the best way to approach this? is there a way that it will just automatically update a league table based on the drop downs? how do i define the criteria needed for each of the selections in the drop downs? will i need to create a league table for each of the values in the drop downs? so 12 for new and 12 for used?
once i get the league table up and running it shouldnt be too difficult pulling in the information i need. probably a case of doing a vlookup.
