+ Reply to Thread
Results 1 to 2 of 2

copy column from pivot table

  1. #1
    Registered User
    Join Date
    01-26-2007
    Posts
    21

    copy column from pivot table

    How can I copy a column "overtime" d5:d35 from pivot table at the sheet1 to the sheet2.
    I would like copy only values.
    I know that I can select range d5:d35 copy then
    open sheet2 paste special only value but I would like to know how write cod
    Last edited by barkarlo; 10-25-2008 at 11:13 AM.

  2. #2
    Forum Contributor
    Join Date
    07-09-2008
    Location
    Dallas
    MS-Off Ver
    2007
    Posts
    121
    Can you highlight the range d5:d35, right click / copy, move to the desired location on the other tab, right click / paste special, then choose 'values'?

    I'm using Excecl2007 and that works for me.

    Hope that helps!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1