Extracting Data from a table using a keyword

A

antrance

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
 
G

Gord Dibben

Data>Filter>Autofilter should do the job.

Copy the results to another sheet for reporting.


Gord Dibben MS Excel MVP
 
S

Sean Timmons

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.
 
A

antrance

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
How to extract data from a spreadsheet into a form/create form from spreadsheet data 3
Creating a Chart on form from selected data in query. 0
How to filter rows data based on background color of individual cells 3
Extracting Data 2
Extract data in rows (with line breaks) to form a table 0
Linking data in MS Word into Excel 5
producing a report via a keyword - filtering and macros not suitab 2

Top