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!