separate data in a table
 

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?

separate data in a table
 

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?

separate data in a table
 

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?

separate data in a table
 

Not knowing your format specifically, you can redo line numbers individually
in the filtered mode, or you can copy and paste the filtered data to a blank
sheet and then manipulate it at will.....

Vaya con Dios,
Chuck, CABGx3


"Hobbes2006" wrote in message
...
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?