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