i am a new to excel.
i recently tried to build a page that calculate profit by agent an
agents's account.
our company have about 10 agents and each agents have about 10 account
associated with that agent.
i used combobox and populated with a list of agents. that was eas
enough.
now i want to fill second combobox to be populated with that agent'
account.
please advice me of best way to do what i explained.
i also want to make it easy to add new agent and account.
i speak php and actionscript so i am ok programer.
thanks in advanc
JulieD - 28 Sep 2004 13:14 GMT
Hi
you didn't say how you created the combo box ... so i'm not sure if the
following link will work for you - but it could be worth checking out
http://www.contextures.com/xlDataVal02.html
it's Debra Dalgleish's site on Data Validation - Dependent Lists
Cheers
JulieD
> i am a new to excel.
> i recently tried to build a page that calculate profit by agent and
[quoted text clipped - 12 lines]
>
> thanks in advance