Select the 5 rows then hit F5 and SpecialVisible cells onlyOK.
Copy and paste those.
Gord Dibben Excel MVP
On Mon, 29 Aug 2005 13:44:00 -0700, "achidsey"
(notmorespam) wrote:
I have a spreadsheet where I can click on the "1" "2" "3" buttons to the
left to make different summary levels appear.
When I click on "2", I have just the five rows with subtotals visible.
I want to just cut and paste those just these rows rows to a different
spreadsheet, but when I paste, all the rows are pasted in, not just the
subtotals.
Is there a way to just paste the subtotals?
Thanks,
Alan
|