Thread: Find and Copy
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
QPapillon QPapillon is offline
external usenet poster
 
Posts: 12
Default Find and Copy

they aren't all exactly alike - but they all have a least one word in common,
does this still apply?

Thx! -C.

"Trevor Shuttleworth" wrote:

Carol

you could use AutoFilter to select the entries and then select the visible
cells/rows and copy them to another sheet.

Regards

Trevor


"QPapillon" wrote in message
...
Good Morning,

I have a list of over 2000 items with several columns per entry. I was
able
to use the 'find' function to find entries with a specific word in them
and
where they were within the list but now I'd like to isolate those item,
copy
them and place them in a separate sheet. Is there anyway to do this
easily?

Thanks!
Carol