Once you have setup a Subtotal sheet you are ready to capture the data you are looking at using copy but it copies ALL the data not just the results from your subtotal.
In Excel 2007 and 2010 its hard to find a way to copy visible data only
Use the QAT menu dropdown to customise the menu and find the command called SELECT Visible Cells, add it to your toolbar.
Or use the shortcut below:
ALT +; to select the data then CTRL + C then go to Sheet 2 then CTRL + V to paste.
