I need help with some code in the attached excel sheet. I need to calculate statistics on the "Map Bumper Sticker" sheet pulling data from Flat File sheet. Just summing a column on one sheet for each team with that month is shown in a drop down menu for seven teams. There are 5 columns that need to be added for 7 different teams. See the attached workbook. The workbook contains two sheets. One with the data, the second is where I need a drop down menu for the month in the column B of the first page. Need this to be dynamic so as we continue to add months and data the drop down will update. The second sheet provides monthly summaries based on columns highlighted in yellow on the second sheet.
Let me know if you have question. Appreciate the help in advanced. I am extremely grateful for the assistance.
Bookmarks