Macro to calculate Month to year sales based on month selection

Take a look at the attachment to see if I've got it right. There's a dropdown in E1 to pick the year (Apr-Mar). This dropdown is tied to a dynamic named range on sheet2. You can add more years to the list on sheet2 and the dropdown should adjust automatically. There's a second dropdown in E2 to pick the month. This is tied to a named range on sheet2, as well. The sum is shown in E3 using the formula:

=SUMIFS($B$2:$B$5000,$A$2:$A$5000,">="&VLOOKUP($E$1,Sheet2!$A$2:$B$13,2,FALSE),$A$2:$A$5000,"<="&EOMONTH(VLOOKUP($E$1,Sheet2!$A$2:$B$13,2,FALSE),0))

This should calculated the chosen monthly total. It uses the dropdown info to do a lookup on sheet2 for the start date of the range, which is calculated by the following in shee2 B2:

=IF(A2="","",DATE(IF(MONTH(DATEVALUE(Sheet1!$E$2&" 1"))>=4,2015,2016),MONTH(DATEVALUE(Sheet1!$E$2&" 1")),1))

It is a bit hard to explain, but the attachment should help to clarify how it works. The formula is currently set up to look at up to 5000 rows of data on sheet1. If you need a bigger range, just change the "5000"s in the formula to something bigger.

Ah! I understand now. Try the new version in the attachment. There are now start and end dates on sheet2, and the Sales formula in E3 is:

=SUMIFS($B$2:$B$5000,$A$2:$A$5000,">="&VLOOKUP($E$1,Sheet2!$A$2:$B$13,2,FALSE),$A$2:$A$5000,"<="&VLOOKUP($E$1,Sheet2!$A$2:$C$13,3,FALSE))

Glad to help, good luck!