Saving Totals Only
Excel 2003
I have spreadsheets containing thousands of lines of detail and then use Subtotals to produce summary data. I have ten spreadsheets like this and would like to take the totals only into a new spreadsheet, using a different set of totals and putting them into columns across the spreadsheet (these are quarterly figures), but even with copy and 'paste special' I get all the detail lines in the new spreadsheet - is there any way of saving JUST the totals?? |
Saving Totals Only
Hi Nina
With just your Subtotals visible, mark the range you want and then use Alt + ; (that's Alt and semicolon) Type Control + C to Copy, move to new Sheet and Control +V to Paste. -- Regards Roger Govier "Nina S." <Nina wrote in message ... Excel 2003 I have spreadsheets containing thousands of lines of detail and then use Subtotals to produce summary data. I have ten spreadsheets like this and would like to take the totals only into a new spreadsheet, using a different set of totals and putting them into columns across the spreadsheet (these are quarterly figures), but even with copy and 'paste special' I get all the detail lines in the new spreadsheet - is there any way of saving JUST the totals?? |
All times are GMT +1. The time now is 11:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com