| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 =/ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 =/ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 =/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting data from one sheet based on data in another - VLookup? | Excel Worksheet Functions | |||
| Extracting data | Excel Worksheet Functions | |||
| Need help extracting data.... | Excel Worksheet Functions | |||
| Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
| Extracting data | Excel Worksheet Functions | |||
Linear Mode
