Macro VBA Excel - Reference to a range of conditioned cells to fill in in other side cells

First, thanks for the help. I made a test macro to see if it worked and it was OK. However, it references a single cell due to the test. Now, I need to extend this macro to a range of cells, where ...