This one sounds fun. I have it figured out using an array but I need to know if you know what the maximum number in column A would be. Right now you show 6 being the highest number but I'm sure it is probably not the highest in your final workbook. If the highest number changes let me know the max it can go so I know how far to carry the array.

Thanks