Sorry, I thought this was solved. I don't understand your requirements now compared to the before and after in the workbook you provided. Instead of going down rows, like in the workbook, you want to go across the columns? Why provide a sample that shows the opposite of what you require. At any rate, I'll work on this and try to resolve it for you.