In Excel if you only want to copy the data (values) in the cell(s) do a
copy then instead of paste use Paste Special and select Values.
Bob J.
Guam U.S.A.
At10:00 AM 10/15/2005, roger helbig wrote the following message:
==-==-==-==-== Begin Quoted Message ==-==-==-==-==
>
>Related to Rob's Question, using Excel 2003, I am trying to
>sort on sub-totals. I have created the sub-totals and set
>up the collapsed worksheet, but I need to copy only the
>visible values into a new worksheet and then I will be able
>to sort on the sub-totals, but I can not seem to find how
>to copy the visible values...
>
>Roger Helbig
>
==-==-==-==-== End Quoted Message ==-==-==-==-==
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.12.0/134 - Release Date: 10/14/2005
--
----------------------------------------
To unsubscribe, mailto: [EMAIL PROTECTED]
Is your picture included in the Official Win-Home List Members Profiles Page?
http://www.besteffort.com/winhome/Profiles.html
If not, write to: [EMAIL PROTECTED]
