I need a loop that goes across columns, when it hits a cell E.G 'Team 1' the loop then goes down to a particular row E.G row 11 and fills in team member names that it gets from a list on a different sheet, once it has filled in all of 'Team 1' members, it goes back to moving across columns until it hits the next cell with E.G 'Team 2' ...

Anyone able to provide some code or point me in the right way of a decent tutorial page?