You can only copy cells between two Excel sheets, irrespective of whether or not they are in the same workbook.