copy and paste from one worksheet to another in a specific cell and in sequence

  • Hi All,


    Can anyone help. Need a macro/vba to copy and paste from one worksheet to another in a specific cell and in sequence and loop to the end. Worksheet1, there is only one column but format is the same and in sequence and is in LDIF format.


    Example:
    Worksheet1: user: Joe Blogs
    Title: Administration


    user: Mary Smith
    Title: Cleaner


    etc.....


    In worksheet2: username: jbogs
    username: msmith
    etc.....


    Data in WRKSHEET2 in column needs to be copied and pasted to worksheet2. in the blank cell in sequence. The output will be;


    Worksheet1: user: Joe Blogs
    Title: Administration
    username: jbogs


    user: Mary Smith
    Title: Cleaner
    username: msmith



    Cheers.

Participate now!

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