Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Data from a table using a keyword
I am struggling with an excel spreadsheet that has been inherited from
another person and I would like to extract data from the table using 'keywords' that will then copy the row/s depending on the keyword. The client has requested that the information that used to be bundled together be seperated and reported on. Thanks for any help you can provide Ant |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Data from a table using a keyword
DataFilterAutofilter should do the job.
Copy the results to another sheet for reporting. Gord Dibben MS Excel MVP On Mon, 5 Feb 2007 10:42:01 -0800, antrance wrote: I am struggling with an excel spreadsheet that has been inherited from another person and I would like to extract data from the table using 'keywords' that will then copy the row/s depending on the keyword. The client has requested that the information that used to be bundled together be seperated and reported on. Thanks for any help you can provide Ant |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Data from a table using a keyword
Just to expand a litle on the below:
When you click the drop-down arrow, select (Custom) and select contains in the first drop-down of the pop-up box, then your text strign in the second box. "Gord Dibben" wrote: DataFilterAutofilter should do the job. Copy the results to another sheet for reporting. Gord Dibben MS Excel MVP On Mon, 5 Feb 2007 10:42:01 -0800, antrance wrote: I am struggling with an excel spreadsheet that has been inherited from another person and I would like to extract data from the table using 'keywords' that will then copy the row/s depending on the keyword. The client has requested that the information that used to be bundled together be seperated and reported on. Thanks for any help you can provide Ant |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Data from a table using a keyword
Many thanks for this - I was hoping there might be a way to do it by formula
as I have to look at data from somewhere in the region of 200-250 different worksheets... "Sean Timmons" wrote: Just to expand a litle on the below: When you click the drop-down arrow, select (Custom) and select contains in the first drop-down of the pop-up box, then your text strign in the second box. "Gord Dibben" wrote: DataFilterAutofilter should do the job. Copy the results to another sheet for reporting. Gord Dibben MS Excel MVP On Mon, 5 Feb 2007 10:42:01 -0800, antrance wrote: I am struggling with an excel spreadsheet that has been inherited from another person and I would like to extract data from the table using 'keywords' that will then copy the row/s depending on the keyword. The client has requested that the information that used to be bundled together be seperated and reported on. Thanks for any help you can provide Ant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - Extracting specific data | Excel Worksheet Functions | |||
Another Exciting Data Table Question!!!! | Charts and Charting in Excel | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |