Macro to find SKU in column; then copy data in row and paste special (values)

Hi all

I'm trying to do the following:

I have a list of SKU's in column D, descriptions in column E and data in Column F and G

I want to build a macro that finds a SKU that I punch in to a cell (D1), to then search the column of D (2:58) for this SKU, and copy the data from Column G (Which is a vlookup) and 'paste special values' into Column F.

The SKU in cell D1 will change, which is why it will need to probably index search through the column of D, but I've tried a number of times and simply cannot get it to work.

Any help would be wonderful

Starkey