use names | define

if you choose georgia, in the corresponding cell will show only
atlanta thru ahtens ??



On Apr 7, 9:09*am, "greenbg via OfficeKB.com" <u34910@uwe wrote:
Hi Eeveryone
*I have a drop-down list box. I would like to know is any way that add
information in it or shall I look for a different way to handle this
information. I am using excel 2003. See exmaple below:

GEORGIA
Atlanta
Valdosta
Albany
Athens

Atlanta thru Athens fall under GEORGIA

Thanks

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200804/1