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.

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.

Hi,

May I request you to mail me the workbook at and
explain the problem very clearly.

--
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.

Sorry - it's a work file and considered company property so I can't send the
file. Like I said I'm not an Excel student but it seems to me that if I can
FIND the specific data easily, there must be a function to then select and
copy that data. I tried the GO TO which worked great for blank cells but I
can't seem to get it to find my data using the *TIQSB* criteria in the
REFERENCE box so I'm probably not using that correctly. I could use an
auto-filter except the data is in many, many columns. I tried to figure out
how to quickly put all the data in one column so I could use the auto-filter
but all the functions I found to combine columns just wants to count them or
concatenate them, not stack them.

"Ashish Mathur" wrote:

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.