How are you copying the worksheet?
To copy a complete sheet right click the spreadsheet's tab, (at the bottom), and select Move or Copy. In the new window you now have choices.
First, which 'Workbook' do you want to move/copy to? Use the pull down list or if it is the same workbook, accept the default.
Second, decide if you want to 'move' the sheet or to 'copy' it. To move it, do nothing. To create a copy, click the "Create a copy" option.
Third, decide where you want to sheet to go. The larger window will list all the existing sheets and the moved/copied sheet will be placed before the sheet you highlight, unless you select, 'Move to end'.
I hope that helps.
Was this reply helpful? (0) (0)