| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter data
I receive a sheet that has the following information in column A: client ID,
and I have several IDs. I want to obtain only the information that corresponds to ID A001 and ID A002, creating one new sheet for each ID. Is this possible? Thanks in advance Regards, Emece.- |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter data
Click on the column A header cell and pull down:
Data FIlter Autofilter make your selection and then copy the visible rows to another sheet. -- Gary''s Student - gsnu200906 "Emece" wrote: I receive a sheet that has the following information in column A: client ID, and I have several IDs. I want to obtain only the information that corresponds to ID A001 and ID A002, creating one new sheet for each ID. Is this possible? Thanks in advance Regards, Emece.- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Data - Filter - Auto Filter | Excel Discussion (Misc queries) | |||
| Excell Data Filter Fails to Integrate New Data-rows | Excel Discussion (Misc queries) | |||
| in data/filter/auto filter | Excel Worksheet Functions | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Hybrid Mode
