Code that allows User to Input Begin, End Date, and Team Number

MCalk - Feb 26, 2016 at 02:11 PM

I am looking for VBA code that will allow a user to input the begin and end date they are looking for, as well as team number.

For example, in Sheet1, I have a 4 cells where the user can input Begin Date, End Date, Team Number, and Color.

In Sheet2, I have data from each day, each team, etc. Based on what color and team the user enters, I want it to populate in Sheet1 with how many of each color showed up for each team during the time period they entered. Thank you in advance.