PDA

View Full Version : Solved: output subtotals only to new sheet



pdeshazier
12-27-2011, 12:44 PM
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!:dunno

Aflatoon
12-28-2011, 06:47 AM
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
12-28-2011, 07:23 AM
thank you so much! it worked!!:clap:


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.