View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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?