Copy and paste proforma spreadsheet with subtotals

[Clott]

Hi
I have a proforma spreadsheet that I use each month to enter weekly wage information, subtotalled into depts., PAYE, NI etc. On a previous version of Excel I had no problem in copying the previous month's sheet and pasting to the new month sheet then deleting data but maintaining subtotal formulas, formatting etc. However, since changing to Office 2010, when I copy the spreadsheet, the pasting is all over the place. I have googled and searched various answers but I can only find instructions on how to copy and paste subtotal results, which I don't want. I want to replicate the exact sheet.
I hope I have explained the problem correctly. Any help would be appreciated.
Many thanks
Claire

[6StringJazzer]

If you are using this to create a new sheet in the same workbook, you don't need to copy & paste. You can right-click on the tab and then "Move or copy..." to make a copy of the sheet in the same workbook. I don't know why you are having a problem but this should work correctly in any version of Excel that supports multiple worksheets.

[6StringJazzer]

Hi Claire. I see you have marked this thread as SOLVED. Can you please share your solution with us? Thanks.

[Clott]

Hi Jeff, I simply did as you said - right-clicked on the tab and copied. I'm afraid I didn't even know that! I thanked you in the 'add reputation' box but I don't know if it appeared. Anyway, I am very happy now