Yes, I was refering to sheet2 in relation to post #1. I never mentioned sheet #4 because it was set-up the same, but because I posted sample file I mentioned it.

I was trying to put dat in to next column rather than row.

As you cam see sheet2 (E2 to N2) populates sheet1 B10 to B19. Was wanting to know if a userform can be created for that and other sections, thanks