Using VBA Macros to Copy and Paste Without Overwriting Previously Copied Data

Hi All - I am working on a large spreadsheet where I am copying, pasting and rearranging data by column on a weekly basis. I am trying to create a macro the does this automatically for me but I need it to NOT overwrite previously pulled over data from prior weeks as it will be edited and I do not want to have to redo the work. I would like the code to recognize the last copied cells from the previous week and only copy over new data. Can someone assist me in completing this code to do so? This is what I have as of right now:

Please Login or Register  to view this content.

Any help or guidance is greatly appreciated!! Thank you!!

Thank you 6StringJazzer! I appreciate your time. I uploaded an edited version of the file to give a general idea of what I am working with. In this example, I have rows 2-14 copied over from sheet1 to sheet2 and have made some edits. I now need row 15-20 to copy over without overwriting the information in rows 2-14.

A demonstration as a starter :

PHP Code: 

Sub Demo1()
    Dim R&
        R = Sheet2.UsedRange.Rows.Count
    With Sheet1.UsedRange.Rows
        If R < .Count Then .Item(R + 1 & ":" & .Count).Copy Sheet2.Cells(R + 1, 6)
    End With
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

Thanks for assisting, Marc L! Unfortunately, this code doesn't prevent any edited data from sheet2 from being changed back to the source data on sheet1 when running the Macro. Any suggestions?\


Thank you!