Hello people

I have the following problem.

I have one sheet with a table that contains in each row a code and the 8 next cells (to the right) have formulas in it.
I have about 20 rows, each with a code like "9x-wa", "SHBJ", "3dx2", etc

In another worksheet this formulas need to be aplied according to the Code.
So I have a cell in each row with these same codes, now I need to copy the formulas from the Sheet 1 to Sheet 2.

I am pretty enw to VBA, so I was following a (copy, paste) logic, like:
Copy code (9x-wa) from Sheet 2, Find "9x-wa" in Sheet 1, Copy the 8 cells to the right. Go back to sheet 2 and paste acording to row.....

But I figured this is a pretty ugly way aint it? Is there any VBA funcion to make it easier?

Thanks in advance.