Shortcut to repeat instruction over multiple cells

Hi all, I have a snippet of code below which basically looks at the value in cell AG10 (10,33) and then in all valid rows in column AG (33) populates the values drawn in. This is rows 1,2 and 3 of the code below. Rows 4,5,6 do exatcly the same, but this time refernece cell AH11 (10,34) and then in all valid rows in column AH (34) populates the data.

I need this to do the same up to column OC (212) but am hoping that instead of my copying the same 3 lines of code multiple times there would be a better way to code this to do it in a few lines?

Any help much appreciated and suggestions welcome

Please Login or Register  to view this content.

Perfect thanks