Hi - I have the following code, but want to select the "active" sheet and the "lookups" sheet to copy and move to a new workbook.
Because the "active sheet" name changes, it won't always be "XYZ123" hence the need for the active sheet.
The code below is a start, but will need to be amended so it selects the "active sheet" and the "lookups sheet", and creates a New Workbook, that will solve my problem.
thanks.
Sub MoveSheetsNewFile()
'
' MoveSheetsNewFile Macro
'
'
Sheets(Array("XYZ123", "Lookups")).Select
Sheets("Lookups").Activate
Sheets(Array("XYZ123", "Lookups")).Copy
End Sub
Bookmarks