Hi Jeremy, Not sure what this means.

Then create sheets based on value in A, and copy the data onto each
sheet based on the data in A and the name of sheet.



"J.W. Aldridge" wrote in message
...
Headers on row 1.
Data in A:AD
Criteria in column B.

Delete rows if the value in row B does not equal "Apples" or "oranges"

Then create sheets based on value in A, and copy the data onto each
sheet based on the data in A and the name of sheet.