Posts by Lizziew71

    I'm trying to use this, but need to make some adjustments but am not able to figure it out. I'm not very advanced with VBA.

    Code
    This is the code you provided:
    Option Explicit
    Sub Upload()
    Range("A5", Range("C" & Rows.Count).End(xlUp)).Copy Sheets(2).Range("A" & Rows.Count).End(xlUp)(2)
    Range("A5", Range("C" & Rows.Count).End(xlUp)).ClearContents
    End Sub


    My questions are:
    1. How do I do this between two different workbooks, instead of sheets?
    2. I don't want to clear contents, I only want to add new content. How do I do that?
    3. I want to copy only specific cells in the row (for example, A1 to A1, B1 to B1, C1 to D1)


    I couldn't find a forum to post this question.


    Any help would be appreciated.


    Thank you