+ Reply to Thread
Results 1 to 2 of 2

Macro to Copy Pivot Table and Paste a Regular Data Table in the Same Position

  1. #1
    Registered User
    Join Date
    07-11-2011
    Location
    Gatineau, QC
    MS-Off Ver
    Excel 2010
    Posts
    50

    Macro to Copy Pivot Table and Paste a Regular Data Table in the Same Position

    Hello all,

    I am looking for a macro that would copy a pivot table and paste the pivot table values only with the pivot table format (i.e. a regular data table). I want the regular data table to replace the data table in the worksheet, not to be copied to another location.

    All I have been able to find thus far is a macro that will copy a pivot table and then paste the values and formatting in another worksheet.

    Any help would be hugely appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,656

    Re: Macro to Copy Pivot Table and Paste a Regular Data Table in the Same Position

    I think you will need to copy the tables values and formats before deleting it.
    This code creates a copy immediately below original table and the deletes shifting cells up.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to copy a table and paste in another table (based on certain conditions)
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-22-2013, 01:14 PM
  2. VBA Copy column data from one table and paste into another table
    By escobf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2013, 06:59 PM
  3. Macro Help Needed - Link Pivot Table Filter to Regular Table AutoFilter
    By ycx1129 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2011, 12:54 PM
  4. Macro to Copy Data from a Pivot Table
    By mr_diss in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2007, 05:10 AM
  5. Copy Pivot Table Data and Paste into New File
    By S Sainsbury in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2005, 09:20 AM

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