Obviously, you have simplified your question for us (by the way, that is
almost always a bad thing to do as it usually leads to unusable solutions;
that is, solutions that work for your example, but that cannot easily be
extended to your real situation)... I'm assuming we are talking about more
than two items in Column A... can these repeat (that is, can "abc" be listed
more than once) and, if so, what do you want to happen with the row for that
repeated data?

--
Rick (MVP - Excel)


"J.W. Aldridge" wrote in message
...
Column A on active sheet has contains a list of one or two values.
"abc"
"def"

For each value of abc, create a sheet entitled "product of abc" and
opy the entire row (or at least a:g) to that sheet.

For each value of def, create a sheet entitled "product of def" and
opy the entire row (or at least a:g) to that sheet.