I have three column - Column A, Column B, Column C
In Column A have different sort of data number
In Column B, I have a multiple number ranging from 1 - 10 till row 400.
In Column C, I have different type of data name.
My concern is where Column B = 1, 4, 5, copy the data of Column C into Column A
Can you do this in VBA coding. VBA must detect 1, 4, 5 til the last row. The number changes every week.