i need help to copy cell value, find value in other worksheet, then paste row where the found cell value is

  • Hi, I'm new to VBA, i need help to copy cell value, find value in other worksheet, then paste row where the found cell value is. I am using a workbook as a template so each user can use it.

    I have a worksheet called "Survey" I want a vba code to copy the cell value in cell "J5"

    Go to worksheet "Raw_Data" find the value of the cell J5 from the sheet "Survey" in column "AW" on the Raw_Data tab then paste special that particular row and then save the workbook as an xlsx and with the template clear the contents in cell J5 on the "Survey" sheet.

    This is what I have so far but I am stuck finding and pasting the data.


    Edited once, last by Carim: Added Code Tags ().

  • I'm not sure that I understand exactly, but maybe


    If not attach an example workbook.