Extracting Data

[suzy]

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 =/

 

[Otto Moehrbach]

Suzy
Look up autofilter in help. Come back if you need more. HTH Otto

 

[Gary''s Student]

First use autofilter and then copy/paste