Complicated data entry ?

I would like to have a spreadsheet on which I can enter services
automatically. Problem is each differrent service has different
numbers of elements which make it up.

For example:

FRAME PORT LINE PVCa PVCb ROUTER
ATM PORT LINE SCR
SMTP SUBS TRAFFIC AV SCAN

And I want, on another sheet, to choose (from a drop down), one of the
services (in this case, FRAME or ATM or SMTP) and get the service
elements automatically added so the result looks like

FRAME PORT
FRAME LINE
FRAME PVCa
FRAME PVCb
FRAME ROUTER
SMTP SUBS
SMTP TRAFFIC
SMTP AV SCAN

I'm an intermediate user of Excel, with little macro and NO VBS
knbowledge, but I can pick it up if needed. Does anyone have any
pointers to potential methods of how to actually do this ?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/