On Tuesday, March 31, 2015 at 12:17:13 PM UTC-7, Claus Busch wrote:
Hi Howard,

Am Tue, 31 Mar 2015 12:01:06 -0700 (PDT) schrieb L. Howard:

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

that is much easier than before.
Please look again in OneDrive for your Workbook.


Regards
Claus B.

Hi Claus,

That is looking good, but I find it has some trouble dealing with the index numbers that have the serial numbers in two rows.

I devised a much shorter version of data and adjusted the code to fit it. Easier and quicker to run and view results. Same data just much less of it.

Run the code on Orginal List sheet, then go to New List sheet and look at column M and down. Column M is 12 columns from B where the serial numbers start. The serial numbers on Orginal List are one row of 22 or two rows of 11.

I sense what is happening, I think, but don't know how to explain it or fix it.

https://www.dropbox.com/s/ecqtrep6ax...sion.xlsm?dl=0

Howard