I am looking for data in a spreadsheet containing a certain word. If i do a
Find All,
I am given all of the rows that contain the word. Is there a way to then
copy all of that data, or the specific rows that contain the keyword?

I find myself clicking each line found in find all, going back to the
spreadsheet, copying and pasting in a new spreadsheet. I then keep repeating
this task. there has to be a better way.

thank you,

Hi Scott,

I am given all of the rows that contain the word. Is there a way to then
copy all of that data, or the specific rows that contain the keyword?


You can select all entries in the listbox that shows the found lines (e.g.
by holding the shift key whilst pushing the down arrow), then hit copy/
paste somewhere else.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Thank you for the quick reply but that method is not working for me. I have
tried that.

"Jan Karel Pieterse" wrote:

Hi Scott,

I am given all of the rows that contain the word. Is there a way to then
copy all of that data, or the specific rows that contain the keyword?


You can select all entries in the listbox that shows the found lines (e.g.
by holding the shift key whilst pushing the down arrow), then hit copy/
paste somewhere else.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Are you looking for the string in just one column?

If yes, then maybe you could apply Data|Filter|Autofilter to that column.
Filter on that column (Custom|contains (yourstringhere))
then copy the visible rows and paste whereever you want.


Scott H wrote:

I am looking for data in a spreadsheet containing a certain word. If i do a
Find All,
I am given all of the rows that contain the word. Is there a way to then
copy all of that data, or the specific rows that contain the keyword?

I find myself clicking each line found in find all, going back to the
spreadsheet, copying and pasting in a new spreadsheet. I then keep repeating
this task. there has to be a better way.

thank you,

--

Dave Peterson