i have the very simple problem of copying a worksheet from one workbook and placing it in another one. The macro = bringg() could hardly be simpler
Sub bringg()
Workbooks("Pajd.xlsx").Worksheets("EG62149").Copy
Workbooks("Flights.xlsm").Worksheets("Sheet1").Paste
End Sub
BUT instead of putting thecdata from EG62149 on Sheet1 it opens a completely new workbook called Book1 and pastes the data on Sheet1 in this new workbook.
Probably "I can't see for looking" but what did I do wrong, please ?
Bookmarks