Referring to the attached file, I am trying to write code that will find the first three cells in column C based on the value of cell H4 in the sheet Boys8. Then I want to copy the contents of the corresponding cells in columns A, B, C and Cell A2 to the corresponding columns in sheet TeamQualifiers. For example copy these cells from rows 6, 10, 12 and A2:
ANDREW L agn St. Agnes Grade 8 Boys
ANTHONY J agn St. Agnes Grade 8 Boys
MATTHEW B agn St. Agnes Grade 8 Boys
and then paste them into sheet TeamQualifiers in the corresponding columns.
Then I need to repeat the process using the value in cell H5 (St. Gerald) and paste the similar data starting with the first blank row in TeamQualifiers. I'm relatively new to VBA and would appreciate any help.