MrExcel Publishing
Your One Stop for Excel Tips & Solutions

subtotals


Posted by chrystal on January 24, 2000 3:13 PM

once you've subtotaled data, is there a way to copy
and paste only the second level of subtotals?
in level 2, if you copy two lines of data, you also
copy all rows in between.
i've tried ctrl + only the lines i want
but that is very tedious for hundreds of lines


Posted by Celia on January 24, 2000 3:54 PM

Chrystal
With only the sub-totals visible, click the Edit menu and select GoTo-Special-Visible Cells Only.
Then copy and paste.
Celia