Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing Criteria to a Pivot Table from combo boxes | Excel Programming | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Create/copy combo boxes in one range if condition is met in a different range | Excel Programming | |||
Finding a record using multiple combo boxes as my search criteria | Excel Discussion (Misc queries) | |||
Using SUM with worksheet range selected by two combo boxes | Excel Programming |