VBA To Create Multiple Queries When Data Varies

Hi All,

I have a database and I need to be able to separate data the same way each time, but the data is always different. I have attached a sample spreadsheet as an example. Basically, I'll have the "Main" tab and then will need to separate the data by Team, By Year and then by State. The way I am accomplishing that now is by manually filtering every single time (terrible!). The Sample file shows what the main data format looks like and then a sample breakdown of TeamA (only), I'll create separate files for TeamB-TeamD and break the data out the same way.

So ideally, I would like to be able to upload this "Main" data dump to MS Access and with a combo box set to "Team A" and then create all the individual tabs or queries that I make manually by filtering. The thing is that every time I have a new data dump there will always be different numbers of Teams, States and Years. So I think the VBA would have to know to only create tabs/queries where years, teams and states are present and exclude where there are gaps.


Thanks!!!