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.

    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