Hi,


I Have the last two sheets (which are inserted at the end of a my workbook(MainFile) that I want to move to a new work book.

The issue is I have to move them one by one and the new book that is created --well the name changes--So selecting it is difficult.

So far I have..

Set ThisWorkbook = MainFile

 'Find the last sheet
    Sheets(Sheets.Count).Select

 'Move to New Workbook
    ActiveSheet.Move
    
 MainFile.Select 'going back to the mainworkbook to grab the second piece of sheet 

'Now trying to grab the last sheet
  Sheets(Sheets.Count).Select
but can't figure a clever way to select the new workbook created

Any help?