Working from a master list within different workbooks.

[Paxmal(AT)operamail.com]

Hello,
I have read through many posts and have not yet found my particular question
addressed even in an oblique way.

I am a landscape architect, my plans contain a wide variety of plant
species, varities, and sizes.

I would like to create a master list of all species names, varieties and
sizes, such that for each project I can open a new workbook and populate the
list of plants with use of my mouse with no keyboard entries necessary.

There are three variables for each entry: species (Acer rubrum) variety
('October Glory') and size (2-2.5" caliper), such that for any given species
there are several to many varieties and perhaps 12 diferent size options.

I find that it is a great time sink to input these data over and over again
for each plan/workbook and the auto-complete function and 'right click' "pick
from list" only works for previous entries within that column and workbook.

I use excel in more sophistocated ways, but this seemingly simple function
eludes me.

thank you in advance
paxmal

 

[Bob Phillips]

Sounds to me that you want dependent dropdowns. See
http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paxmal(AT)operamail.com"