transfer data range from criteria in 2 combo boxes

Q

Qaspec

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo boxes in excel 6
Finding the right style field in VBA 0
combo box 2
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
fill in data that is not empty 1
Filter with an IF, AND, NOT formula 1
Copy range from Sheet1 into empty range in Sheet2 1
Macro to match 2 column values in different sheets 1

Top