View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default How can i copy the values derived from find and replace?

Are the values all in the one column. If so, try using AutoFilter and then
copy the visible cells.

--
Regards,

OssieMac


"clem" wrote:

I need to get a number of data entries from an Excel worksheet. I did a
"find" and came up with more than 1000 values. How can I copy the values all
at the same time without doing a manual copying of each value/entry? Thanks!