Extracting Data from a table using a keyword

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Data>Filter>Autofilter should do the job.

Copy the results to another sheet for reporting.


Gord Dibben MS Excel MVP
 
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.
 
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

Extracting Data 2
InputBox for a string of 2 to 3 keywords, separated with commas. 2
Extracting data 2
Lookups - how to obtain data from a master spreadsheet into another 5
How to filter rows data based on background color of individual cells 1
producing a report via a keyword - filtering and macros not suitab 1
Extract DAta from text 1
Easily extracting data from one spreadsheet to another 5

Back
Top