Yes. I assume you want to use VBA for this. Just be sure you know the path (and don't change it after setting up the code). Another way is to have the user open the file that you want to copy from/paste to.
old, slow, and confused
but at least I'm inconsistent!
I have used this code below which copies a range of data from one workbook to another, which works fine. I want to take this to another level. How can I copy data from a workbook to another workbook, but not knowing where the last row is
Dim wbTo As Workbook
Dim wbFrom As Workbook
Set wbFrom = ThisWorkbook
Application.ScreenUpdating = False
Set wbTo = Workbooks.Open("F:\DataDatabase.xls", False, False)
.Range("Data").Value = wbFrom.Sheets("DataFrom").Range("DataPaste").Value
MsgBox "All Data Updated"
Application.ScreenUpdating = True
Set wbTo = Nothing
Set wbFrom = Nothing