transfer data range from criteria in 2 combo boxes
 

i have 2 combo boxes "com1" and "com2"

i want the value in "com1" to help me decide which columns to target and i
would like "com2" to decide which rows to target from another worksheet
"sheet2"

example: if the value of "com1" was "red" and the value of "com2" was "5/1/10"
then i can return C5-C35 from "sheet2" into "a1-a31" in the original sheet

example: if the value of "com1" was "blue" and the value of "com2" was
"5/2/10"
then i can return D6-D36 from "sheet2" into "a1-a31" in the original sheet