How to take full advantage of an Excel file?

Question

excel

Good day! There is a pseudocode that I can't implement in vba. I will immediately describe the essence of the issue, and a little lower I will give my pseudocode. There is a two-color column (gray and white (if anyone cares)), so it turns out that in white I have to enter a value, and if a gray color comes across on the cycle path, it should stop and go to the next cycle.
<pseudocode>
color = cell color
Loop while cell color == white Then
I = 7
o = 8
p = 9
condition if i == 7 Then ' How to turn it into a loop? So that it executes in a specific sequence inside the first loop
sheet2.cellB4 = sheet1.cellC2.
etc...
pseudocode>

Answer 1

What will the first sheet look like when filled out?