E
EdE
Hi,
I have a worksheet "Database" which has 3 criteria (Country, St/Prov, and
City)
and 3 items of data (Area, Pop, and Elev) that correspond to the individual
criteria:
Country St/Prov City Area Pop Elev
USA NY NYC 469 8.1e6 33
USA NY Alb 22 .1e6 200
USA NY Buff 53 .3e6 26
USA Ca LA 498 3.8e6 0
USA Ca SF 47 .7e6 52
USA Ca SD 372 1.2e6 72
Canada BC Whistler 62 .009e6 2200
Canada BC Van. 44 .6e6 548
Canada Alberta Calg 281 1.0e6 3438
Canada Alberta Edm 264 .7e6 2192
For example's sake, let's say I wish to populate a worksheet "Form" with
the Area, Pop, and Elev of SD. And I'd like to select my 3 criteria from the
worksheet "Form", even though the data I want resides in the worksheet
"Database".
I want to select the Country in cell A1, the St/Prov in cell B1 and the City
in cell C1. I want an active filter that:
1) When I select the pull-down menu in cell A1, I'd like "USA" and "Canada"
to appear for selection --> I then select "USA"
2) after I select "USA", when I select the pull-down menu in cell B1, I'd
like "Ca" and "NY" to appear without having to run a secondary macro (unless
the macro automatically starts upon selection of "USA") --> I then select "Ca"
3) after I select "Ca", when I select the pull-down menu in cell C1, I'd
like "LA", "SF" and "SD" to appear without having to run a secondary macro
(unless the macro automatically starts upon selection of "Ca") --> I then
select "SD"
4) after I select "SD", I'd like the Area, Pop, and Elev of SD, from the
"Database" worksheet, to be input into the cells I specify in the "Form"
worksheet.
So, it's like a "filter"; however, I'd like to be able to switch over to the
"Database" worksheet at any time and see ALL the info within that worksheet
instead of having all the rows that do NOT meet my criteria be hidden, as
with what happens with a regular filter operation.
My apologies for the novel I just wrote, I just wanted to make sure I was
clear, again, as I'm not the best in explaining myself.
Thanks!
EdE
I have a worksheet "Database" which has 3 criteria (Country, St/Prov, and
City)
and 3 items of data (Area, Pop, and Elev) that correspond to the individual
criteria:
Country St/Prov City Area Pop Elev
USA NY NYC 469 8.1e6 33
USA NY Alb 22 .1e6 200
USA NY Buff 53 .3e6 26
USA Ca LA 498 3.8e6 0
USA Ca SF 47 .7e6 52
USA Ca SD 372 1.2e6 72
Canada BC Whistler 62 .009e6 2200
Canada BC Van. 44 .6e6 548
Canada Alberta Calg 281 1.0e6 3438
Canada Alberta Edm 264 .7e6 2192
For example's sake, let's say I wish to populate a worksheet "Form" with
the Area, Pop, and Elev of SD. And I'd like to select my 3 criteria from the
worksheet "Form", even though the data I want resides in the worksheet
"Database".
I want to select the Country in cell A1, the St/Prov in cell B1 and the City
in cell C1. I want an active filter that:
1) When I select the pull-down menu in cell A1, I'd like "USA" and "Canada"
to appear for selection --> I then select "USA"
2) after I select "USA", when I select the pull-down menu in cell B1, I'd
like "Ca" and "NY" to appear without having to run a secondary macro (unless
the macro automatically starts upon selection of "USA") --> I then select "Ca"
3) after I select "Ca", when I select the pull-down menu in cell C1, I'd
like "LA", "SF" and "SD" to appear without having to run a secondary macro
(unless the macro automatically starts upon selection of "Ca") --> I then
select "SD"
4) after I select "SD", I'd like the Area, Pop, and Elev of SD, from the
"Database" worksheet, to be input into the cells I specify in the "Form"
worksheet.
So, it's like a "filter"; however, I'd like to be able to switch over to the
"Database" worksheet at any time and see ALL the info within that worksheet
instead of having all the rows that do NOT meet my criteria be hidden, as
with what happens with a regular filter operation.
My apologies for the novel I just wrote, I just wanted to make sure I was
clear, again, as I'm not the best in explaining myself.
Thanks!
EdE