In the attached Excel file, Sheet1 has values in Col A and Col B with blank rows in between. I am looking for a macro which will read the values in A2 and B2 and copy in the blank cells below it until it finds the next set of values, then it will copy those down. The last set of values it finds, it must copy down in 9 rows below it. See Sheet2 to see how the blanks should be filled. Thanks.