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.