Follow up question:

Now that I only have lines that include "chair", is there any way to
renumber the lines?

"CLR" wrote:

Data Filter AutoFilter select (Custom) at the top of the Description
column In the dialog box select "contains" and enter chair.......

Vaya con Dios,
Chuck, CABGx3

"Hobbes2006" wrote in message
...
I have a list of items, example furniture. Each line has item number,
description price.

Is there any way, I can sort or split the table by type of item? Example,
is
there a way to move all the lines that have "chair" in the description
either
to the top of the list, or to a separate worksheet?