+ Reply to Thread
Results 1 to 1 of 1

Copy Pivot Table and Move to Filter

  1. 04-16-2021, 09:34 AM #1
    wherdzik
    wherdzik is offline
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    546

    Copy Pivot Table and Move to Filter

    I recorded a macro but it doesnt work since the sheet names will not always be the same. The code always seem to break at
    " Workbooks("Book16").Connections.Add2 _" since this will not always be Book16. Is there a way for it to create a new workbook without putting Book16? 

    Please Login or Register  to view this content.
    Last edited by wherdzik; 04-16-2021 at 10:10 AM. Reason: SOLVED
    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. Loop to copy paste pivot table data changing the filter every time and copy it
    By PaulM100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2019, 06:58 AM
  2. [SOLVED] VBA to filter data from pivot table and move to new docs
    By GregStewartPTC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2018, 12:20 PM
  3. Must Advanced Filter be used with Pivot Table Slicers in order to auto copy and paste data
    By LuScannon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2017, 03:55 PM
  4. writing a macro to move data from a pivot table to individual workbooks sorting by filter
    By Belwether in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2016, 04:59 AM
  5. Change Pivot Table Filter Values and Copy Results Over to New Sheet
    By hamidxa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2014, 06:27 PM
  6. Pivot table filter based on arrays and copy average data to another sheet
    By millatshawn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2014, 05:33 PM
  7. How-to Copy and Paste Values from list into Pivot Table filter
    By MacroNerd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2013, 06:26 PM

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