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

Hi Starkey,

Do you really need a macro as won't this formula in cell F1 do the job?:

=IFERROR(VLOOKUP(D1,$D$2:$G$58,4,FALSE),"")

Regards,

Robert

Could you please upload a workbook with a before and after scenario (devoid of all sensitive information) and I'll see what I can do.

Hi Starkey,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

EDIT

Hi Rob, no matter. I worked through your code and discovered how to adjust it accordingly.

Thank you so much again, this will be really helpful!

Starkey

---

Hi Robert,

Sorry if I'm pushing my luck here, but is it also possible to pull the data from just the 'Before' sheet? In essence, the 'Data' tab is pulling from a number of different sheets in my spreadsheet, so that's not a viable option ongoing.

Cheers,

Starkey

Hi Starkey,

I'm glad to have helped and thanks for marking the thread as solved (and for adding to my reputation )

Kind regards,

Robert