Solved: output subtotals only to new sheet

[pdeshazier]

i have a spreadsheet that is grouped and subtotaled and i only need the subtotal lines saved to new worksheet so i can pull into access and run unmatched query on against another file. i've tried hiding the detail and can SEE only the subtotal lines but if i try to copy and paste these, it still pastes the detail too. is there a way to output only the subtotal lines ? thanks!

[Aflatoon]

Hide the detail, select the data, then press 'Alt' and ';' together to select only the visible cells, then copy and paste-special -> Values to your other sheet.

[pdeshazier]

thank you so much! it worked!!

Hide the detail, select the data, then press 'Alt' and ';' together to select only the visible cells, then copy and paste-special -> Values to your other sheet.