G Gale Apr 14, 2004 #1 After a spreadsheet has been subtotaled, is there a way to copy the subtotals only and paste to another document? Thanks.
After a spreadsheet has been subtotaled, is there a way to copy the subtotals only and paste to another document? Thanks.
F Frank Kabel Apr 14, 2004 #2 Hi try the following after creating the subtotals - group the range so that only the subtotals are visible - select the range - hit F5, click 'Special' and choose 'only visible cells' - after this copy the range and paste it to a different location
Hi try the following after creating the subtotals - group the range so that only the subtotals are visible - select the range - hit F5, click 'Special' and choose 'only visible cells' - after this copy the range and paste it to a different location
