On Tuesday, March 31, 2015 at 10:54:17 AM UTC-7, Claus Busch wrote:
Hi again,

Am Tue, 31 Mar 2015 19:44:46 +0200 schrieb Claus Busch:

what exactly do you want to get into New List? You said the match cell
resize(,12). But most of the match cells are in empty rows. Therefore
there are no other values.

or should I move the match cells before copy the range?
But if I unmerge the cells most of the match cells are in column C and
when I move they are in column B.


Regards
Claus B.

Hi Claus,

Seems I have not explained well enough.

Here is what New List should look like. (No code, just an example)

https://www.dropbox.com/s/nu913gbpyv...mple.xlsx?dl=0

Keeping the sequence of the index numbers in column A in order would be a plus, but a sorting method could probably be worked out to do that on the New List sheet.

Sorry for not making it clearer.

Howard