I think this may be the simplest approach:

Set up a parts table where Column1 contains the System Number and
Column 2 contains the Components. Be sure to use column headings.

Then create a Pivot Table, based on that list, whe
ROWS: System Numbers
DATA: Count of Components

That should generate a Pivot Table that lists all of your Systems.

When you double click on the "count of Components" for any System,
Excel will create a new worksheet that lists all of the Components for
that System.

Is that something you can work with?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=394286