View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default Array instead of loop I'm sure


I hope I got it.
Please look he
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "BlueGrass_New"


Regards
Claus B.
--


It seems to miss the second row of 11 serial numbers for the indexes that are on two rows.

If we look at index 1-1-1-5, which is a double row example:

On Orginal List sheet it is this:

1-1-1-5 14AP606022078875 14AP606022078708 14AP606022076159 14AP606022079004 14AP606022078133 14AP606022079169 14AP606022079172 14AP606022079173 14AP606022079496 14AP606022079216 14AP606022079126

14AP606022078707 14AP606022077563 14AP606022077006 14AP606022079052 14AP606022079024 14AP606022079170 14AP606022079296 14AP606022079295 14AP606022079497 14AP606022079516 14AP606022079221

On the New List sheet it is this:

1-1-1-5 14AP606022078875 14AP606022078708 14AP606022076159 14AP606022079004 14AP606022078133 14AP606022079169 14AP606022079172 14AP606022079173 14AP606022079496 14AP606022079216 14AP606022079126

Followed by blank cells where the second 11 serial numbers should be.

(Not sure how the word wrap will present this, but hopefully its understandable)

Howard