You can try this method - the method simply performs copy and paste using VBA code.
Consider the sample code - the code finds the last row in Column A and copies the cell to L1. You can change it acoording to your needs accordingly...
Code:
Private Sub Workbook_Open()
Range("A1").End(xlDown).Select
Selection.Copy
Range("L1").Select
ActiveSheet.Paste
Range("A1").Select
Application.CutCopyMode = False
UserForm.Show
End Sub
This codes runs as soon as the worksheet opens and it has worked for over a year.
Bookmarks