+ Reply to Thread
Results 1 to 4 of 4

VBA code to export Pivot from masterbook to active sheet on both side

  1. 07-23-2016, 02:40 AM #1
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    VBA code to export Pivot from masterbook to active sheet on both side

    Dear expert

    I have master report saved in path MI_RPTxlsb with one pivot table[EW_Pivot] i want export same pivot table to Q3 Report file.xlsb @sheet!Pivot_GH

    cell of reference to paste from copy selection of pivot.
    i want paste 1st copypivot after pivot end of grand total in first pivot exactly towards right after 4th column
    i want paste 2nd copypivot after pivot end of grand total in down exactly towards right after 14th row

    I want remove only TERM Option in column label in pivot of first copy which is save in right after 4th column
    2nd as it is in master file


    please find the attachment!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-25-2016, 03:29 AM #2
    antoka05
    antoka05 is offline
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: VBA code to export Pivot from masterbook to active sheet on both side

    You could try with this code... open MI_RPT.xlsb and the other workbook in wich to put pivot tables.
    Please Login or Register  to view this content.
    Regards,
    Antonio
    Reply With QuoteRegister To Reply
  3. 07-25-2016, 10:21 AM #3
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: VBA code to export Pivot from masterbook to active sheet on both side

    Hi sir I have tried same code what you brought getting error might be i wrongly used the code better hence add button on run workbook!!
    Attached Images Attached Images
    Last edited by johnmacpro; 07-25-2016 at 10:22 AM. Reason: attach
    Reply With QuoteRegister To Reply
  4. 07-26-2016, 03:26 PM #4
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: VBA code to export Pivot from masterbook to active sheet on both side

    Any experts help on this?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table: Move Metrics by Years Side-by-Side
    By seethesun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2016, 12:40 PM
  2. Macro - Code to open windows side by side
    By bellevue in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2015, 01:08 PM
  3. vba code to update all pivot tables based on cell change on active sheet only
    By seatejo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2014, 08:34 PM
  4. [SOLVED] Export the PrintArea of active sheet to an image
    By bristly in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-18-2014, 08:39 AM
  5. [SOLVED] Excel 2007 Pivot Table side by side row labels
    By arasan25 in forum Excel General
    Replies: 5
    Last Post: 03-13-2013, 05:21 PM
  6. Macro to reference sheet other than active - unhide and/or export
    By Dirty Laundry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2009, 01:00 AM
  7. [SOLVED] Display columns side by Side in the Data Area of a Pivot table
    By Sue in forum Excel General
    Replies: 1
    Last Post: 03-20-2006, 10:15 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1