Paste Special Values

[gwc]

After I use DATA/SUBTOTALs, columns, I click the outline level 2
symbol (at the left of the spreadsheet) to see only the totals and the
grand total.

I then choose a range of cells, click "Go To Special", click "Visible
Cells Only" and click COPY.

On a different spreadsheet, when I click "PASTE SPECIAL", instead of a
box with:
All
Formulas
Values
Formats
etc.

the box lists:
Microsoft Office Excel Worksheet Object
Picture (Enhanced Metafile)
Bitmap
etc.

How do I PASTE SPECIAL VALUES?

 

[Gord Dibben]

Your target workbook and the source workbook are open in two separate
instances of the Excel Application.

Close one and open both books in the single instance.


Gorc

 

[gwc]

Your target workbook and the source workbook are open in two separate
instances of the Excel Application.

Close one and open both books in the single instance.

Gorc







- Show quoted text -

THANK YOU!!!!!!