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.

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.

Thanx.

They will repeat however their will be only one phrase "abc" or "def"
in the string in column A

In other words....

There will be two sheets created. "product of abc" and "product of
def"
Based on cell value in column A, if the contents are "abc" then that
row will paste to row 1 sheet "product of abc"
The next row that matches will follow with row 2, and so on.

Subsequently, if the contents are "def" then that row will paste to
sheet "product of def"
etc.,etc.,