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

Extracting Data
 

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

"suzy" wrote in message
...
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 =/

Extracting Data
 

First use autofilter and then copy/paste
--
Gary''s Student - gsnu200909


"suzy" wrote:

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