Thread: Extracting Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Suzy Suzy is offline
external usenet poster
 
Posts: 21
Default Extracting Data

Hi,
I just want to know how I can extract data from a worksheet and put it into
another worksheet based on a criteria.
For example column B has 'categories' hair, accountants and jewels.
But I want to extract the information only on accountants.
So I want to extract rows based on categories.
Please help =/