Macro - pull data from sheet 1 to sheet 2?

In sheet 1 I have about 40,000 lines of raw data.
For example, A1:K40000 are made up of any combination of letters (product codes), could be repeating codes. Columns B:K have various values.

ABCD
CDEF
OPKED
EJXOS
etc.....


I want to be able to extract or copy from entire row of just product code CDEF to sheet 2. What is the easiest way to do this?

Hi there,

Let me know if the following macro (which utilises Aaron Blood's Find_Range udf) does the job:

Please Login or Register  to view this content.

HTH

Robert