Results 1 to 3 of 3

VBA Code to replicate Pivot table data and apply a % to a value field

Threaded View

kenadams378 VBA Code to replicate Pivot... 08-10-2012, 09:52 AM
kenadams378 Re: VBA Code to replicate... 08-13-2012, 04:31 AM
kenadams378 Re: VBA Code to replicate... 08-13-2012, 05:39 AM
  1. #1
    Forum Contributor
    Join Date
    05-01-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    822

    VBA Code to replicate Pivot table data and apply a % to a value field

    Hi,

    In the attachment i have a piviot table of data, what i need to do is replicate all entries from a sheet called "Original Morca" for each Row Label in the pivot (the amount of rows will change month on month).

    Following the replication i then need to apply the sum of the value in column K by the 5 next to each row label in column L (in the pivot table sheet) and bring all these entries together in 1 sheet.
    Attached Files Attached Files

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