VBA Code to Copy the cell if the cell contain data but if not then move to next column

  • Hi, so I need to modify my code


    here's my code

    the code works but it needs some adjustment if the C column blank, move to column E then copy the data contained there and if there's data on next row of column c, back to C then copy it


    here's what the data looks like


    ProjectDetail
    Project A
    laptop
    monitor
    keyboard
    *blank*
    phone
    mouse
    project c
    windows
    license


    the result of the code


    Project
    Project A
    Project C


    What I want


    Project
    Project A
    Phone
    Mouse
    Project C


    what should I change in order to have the data I want?


    thank you

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!