I need to get a macro that will copy data into specified cells within a row.

SSA will have a value in C4 that will match one of the values in column A in SSB, When the macro runs I would like it to replace the data in various cells from SSA and pplace them in the row where C4 matches the cell in column A, then I want it to select the entire row and copy and paste values as the row has some formulas in that I would no longer want in there.

Hopefully that made sense and you guys will be able to help