Hi,

One way of doing it is the following:

1.

--
Regards,

Ashish Mathur
www.ashishmathur.com
http://www.linkedin.com/in/excelenthusiasts

"kiml" wrote in message
...
I have a large xls file from a system data extract that has unit codes in
thousands of rows with irregular columns. I can do a find function and
locate 758 cells spread throughout the worksheet that contain the
information
I need by using wildcards in the Find function. How can I copy those cells
quickly into a new worksheet? I don't need them sorted or by rows or
associated with any other data - just all the cells that were found
selected
and copied. I can't seem to find a way to do this. I'm not knowledgeable
about Excel but it seems if I can locate all the cells quickly there must
be
a way to then copy and paste these cells from within the Find function.