Need help building a loop

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?

look at for next loops, and offset.

if you could attach a sample, I could illustrate.

Please Login or Register  to view this content.

Thanks very much,

I gave the code a test, it seems to be pulling through the Position, rather than the Full name?

I thought that was a number

Please Login or Register  to view this content.

Really appreciate all your help, however i may have butchered the code a bit too much, it doesn't seem to work at all now - basically runs through the loop doing nothing. A specific line does not seem to be doing anything at all...."For Each Cell in rngRowToCheck.Cells"

Please Login or Register  to view this content.

its cause you've change the "team*" to be "Team*" LCASE changes to lower case, therefore this will never be true, leave the t as lower case.

uncomment the dim statements

if at the top of the code you say Option Compare Text, then there is no need for the Lcase bit.

Ok that has fixed part of the problem, the code now runs and correctly fills out team 1 with the correct team members, however the code then stops with a "Mismatch error" and does not fill out any other team.

Please Login or Register  to view this content.

Anyone able to help?