VBA checking for value (shell-ID) from Sheet1 and Sheet2.

  • So, I am a complete beginner to VBA. Yet, I have been trying to figure out the code for this using various internet sources. So my idea for this is that i have two sheets of data (say sheet1 and sheet2). Sheet1 is my master list and sheet2 has all the major data. Now, the main conditions are that if the Shell-ID of a specific row in sheet1 matches the Shell-ID in sheet2, then just update the phase of the project. But if the value does not exist, then copy other columns like name of the project, project description, phase of the project etc. for that corresponding shell-ID back into sheet1 from sheet2 into specific rows.

    So far, I can only make the entire row copied onto the sheet but not specific parts that I require. Here is my code and what I have tried. Any help will be appreciated.

    Thanks!


    i have added pictures to what my worksheet looks like, for general idea. Here is my current code:


  • Welcome to Ozgrid.


    Please take a few minutes to read the forum Rules (link in my signature below)


    I have added Code Tags for you.


    It is more helpful to attach a small Excel file not images

  • Hello,


    I am trying to edit my post. However, I am not able to. Could you help me out?