Populating Cells From Dropdown Lists Aimed At Other Worksheets?
 

Not looking for a specific solution - rather for a general
method/strategy.

I've got a worksheet where column A will contain, for example,
continent names; column B will contain country names, and columns
C+ will contain properties of the country in column B. e.g.
square miles, population, name of capital city, and so-forth.

The user needs to be able to select a continent for column A from
a drop down list that points to a list of continents that is not
on the same worksheet (which seems to rule out the cell's "Pick
from drop down list" option).

Once a continent has been picked by the user, they need to be
able to move over to column B and pick a country from a drop down
list that has been magically restricted to only the names of
countries on the continent selected in column A.

Once the country has been selected in column B, columns C+ need
tb populated with various country properties from a list on
another worksheet.

There will be 15-20 rows like this - each independent of the
other.

The real data is something called bond "Deals" and "Tranches"....
but that seemed too arcane for the examples and the
"Continent/Country" seems to work....


Can anybody give me some guidance on the general approach?

Some way to fake out the "Pick from drop down" source rule so it
can pick from another sheet?

Floating combo boxes over the column A and B cells?

If combo boxes, what events should I be working with?
Is it possible to re-size a combo box to the default row height?
Trying it manually on a sample sheet didn't seem to work. Minimum
height seemed tb .22 inches.
--
PeteCresswell

Populating Cells From Dropdown Lists Aimed At Other Worksheets?
 

go to

http://www.contextures.com/tiptech.html

Under data validation, look at Dependent Lists.

--
Regards,
Tom Ogilvy





"(PeteCresswell)" wrote:

Not looking for a specific solution - rather for a general
method/strategy.

I've got a worksheet where column A will contain, for example,
continent names; column B will contain country names, and columns
C+ will contain properties of the country in column B. e.g.
square miles, population, name of capital city, and so-forth.

The user needs to be able to select a continent for column A from
a drop down list that points to a list of continents that is not
on the same worksheet (which seems to rule out the cell's "Pick
from drop down list" option).

Once a continent has been picked by the user, they need to be
able to move over to column B and pick a country from a drop down
list that has been magically restricted to only the names of
countries on the continent selected in column A.

Once the country has been selected in column B, columns C+ need
tb populated with various country properties from a list on
another worksheet.

There will be 15-20 rows like this - each independent of the
other.

The real data is something called bond "Deals" and "Tranches"....
but that seemed too arcane for the examples and the
"Continent/Country" seems to work....


Can anybody give me some guidance on the general approach?

Some way to fake out the "Pick from drop down" source rule so it
can pick from another sheet?

Floating combo boxes over the column A and B cells?

If combo boxes, what events should I be working with?
Is it possible to re-size a combo box to the default row height?
Trying it manually on a sample sheet didn't seem to work. Minimum
height seemed tb .22 inches.
--
PeteCresswell

Populating Cells From Dropdown Lists Aimed At Other Worksheets?
 

Per Tom Ogilvy:
http://www.contextures.com/tiptech.html

Under data validation, look at Dependent Lists.

Thanks. I started going through the sample last nite.

Having gotten hung up on "The worksheet range for the list data
must be on the active worksheet", I'm just putting the list data
on the same sheet as the "real" stuff until I figure out what I'm
doing wrong in that respect.

Excel 11.
--
PeteCresswell