Hi,

I have been fiddling with this for ever!! Below is the code i am using to
select the last record of 'Site Reading Log' to a new sheet in the same
workbook called 'Destination'

Question:
How can i copy the last row in 'Site Reading Log' and paste it to a new
workbook, called 'Site Reading Export'.xls, rather to a sheet within the
exiting workbook.

All your help is really appreciated!

Sub Button2_Click()

With Sheets("Site Reading Log") 'source
.Rows(.Cells(Rows.Count, "A").End(xlUp).Row).Copy
Sheets("Destination").Rows(1) 'destination
End With

End Sub

--
Carlee