Excel help, copying data to another workbook.

[Soulassassin]

Here is a basic example mate,

Haven't had time to do you a more in-depth one but it does copy a range of values from the source workbook into a destination workbook and I have kept the code really straight forward (i hope!)

I have also attached a working example (well it worked for me but this is excel)

Extract the folder to "c:\"

source file will be: C:\excel\source.xlsm
destination file will be C:\excel\destination.xlsx

Sub Copy()
    Dim InputFile As Workbook
    Dim OutputFile As Workbook
    
    Set InputFile = ActiveWorkbook
    Set OutputFile = Workbooks.Open("c:\excel\destination.xlsx")

    'Now, copy what you want from InputFile:
    InputFile.Sheets("Sheet1").Activate
    InputFile.Sheets("Sheet1").Range("A1:B10").Copy

    OutputFile.Sheets("Sheet1").Activate
    OutputFile.Sheets("Sheet1").Range("A1").PasteSpecial
    OutputFile.Close savechanges:=True
End Sub

happy to help more but would have to be later in the week

excel.rar

Thank you for your time, if I'm correct does this copy range A1 to B10 from the source and pastes it to A1 in the destination?
However what I am after is copying the end row of a list (constantly being added to) from B to F and pasting it in another document into the end row of that likely longer list (i.e not the same row)

[Mystical_2K]

Thank you for your time, if I'm correct does this copy range A1 to B10 from the source and pastes it to A1 in the destination?
However what I am after is copying the end row of a list (constantly being added to) from B to F and pasting it in another document into the end row of that likely longer list (i.e not the same row)

Yes mate, thats what it does, I will take another look and see what I can put together