Copy to Shared File

[jbmerrel]

I have three computers that can access an excel file on a shared drive. The file is more or less an archive file. I would like a macro that can copy a range of data from sheet1 of a soucre file and paste it to the next available row in the archive file. All 3 computers will have the source file open. But all 3 need to be able to add to the Archive file at any moment. For ease of communication, let name the files as this.



Archive Workbook (Destination File)
Sheet1 Name - "Archive"

Other Open Workbook (Source File)
Sheet1 Name - "Source"
Range("A5:B10")

Thanks in advance,

jbmerrel