+ Reply to Thread
Results 1 to 3 of 3

copy paste only value from pivot table

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

    copy paste only value from pivot table

    I have a pivot table on sheet1 where field "month" is in area page,fields,"emplooyes" is in area row field , "working hours", "vacation","seek-leave" and "work on sunday" is in area data fields.
    On the sheet2 I make table
    emplooyes january february marth
    Now, I want write a cod who will looks emplooyes on the sheet2,month in pivot table and range pivot table. If month is january cod will copy "working hours" and paste only value in column January, if month february cod will copy
    in column february and ect.
    I try with function Vlookup.
    In the column January on the sheet2 I put following formula
    =Vlookup($A2;sheet1!$A$5:$E$56;3;false)
    It is ok!, but when I change month in the pivot table change value on the sheet2 in column January.
    Thank you,

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    Have you tried the GetPivotData function?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

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

    copy paste

    I have 56 emplooyers and If I want see work hours of emplooyers on sheet2 I must write surname for each emplooyers in getpivotdata.It is much complicated.
    Can I put Vlookup function in VBA cod.

+ 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