Need Combo Box to select calendar quarter and year

[psulion01]

I'm building a report and I want to allow the user to select the quarter and year from combo boxes. The selected values should then be used in my SUMPRODUCT calculations to filter the data/calculations based on date ranges.

For example:

User Selects '1st Quarter' and '2005' from the two combo boxes.

Based on this selection, I need to include only rows of data where my 'date' column is between 1/1/05 and 3/31/05.

Is there a clean way to do this so that I don't have SUMPRODUCT formulas for both that start and end date, i.e. SUMPRODUCT((StartDate>="01/01/05")*(EndDate<"04/01/05")*(Sales))

My formulas are getting really hard to read, and I know that what I'm doing is better suited for VB or Access, but I don't know how enough about either to accomplish the task.

If I can get the add-in installed on this computer I'll go ahead and post the sheet I'm working on. In the meantime, if anyone has any suggestions it would be greatly appreciated.

Thanks,
Mike

 

[psulion01]

Hopefully this will help everyone better understand what i'm trying to do... thanks in advance!

Basically, I want combo boxes that allow the user to select the quarter and year (along with region, which I have working correctly), and then have these dates used in my SUMPRODUCT calcs to filter the resulting data. Also, if I could clean up the SUMPRODUCT formulas a bit it would be helpful.

Thanks!

EFS Regional Scorecard.xls
	B	C	D	E	F
6		Quarter:	2ndQuarter	Year:	2007
7
8
9
10	TransactionVolume
11
12		Q2'07	Q2'07	Q2'06	Q2'06
13		Count	Value	Count	Value
14	TypeA	2	$4,577,428	4	$11,854,560
15	TypeB	31	$36,316,713	15	$21,806,212
16	TypeC	118	$44,044,122	134	$100,774,038
17	TypeD	25	$77,963,745	41	$37,559,934
18	TypeE	3	$106,068,438	3	$3,088,167
19	TypeF	26	$3,035,908	32	$13,877,139
20	Other/Gift	12	$11,224,881	11	$6,360,862
21
22	Total	217	$283,231,235	240	$195,320,912
Scorecard

 

[psulion01]

bump for the morning crowd