+ Reply to Thread
Results 1 to 2 of 2

Change Multiple Pivots and paste data in another workbook

  1. #1
    Registered User
    Join Date
    10-21-2021
    Location
    New Delhi
    MS-Off Ver
    MS Office 2016
    Posts
    6

    Post Change Multiple Pivots and paste data in another workbook

    Hi All,

    I'm new to VBA and need your help to automate excel reports.

    Every month I get list of 50+ clients and I've to prepare excel reports for all, where I have to copy data from multiple pivots by changing client name every time and paste special values in another workbook with the same Client Name.

    And then I've copy data from excel and paste in PowerPoint and then send email.

    Can anybody help me out to automate this using VBA

    Thanks in Advance !!!

    Regards,
    Praveen

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,748

    Re: Change Multiple Pivots and paste data in another workbook

    Your duplicate thread has been closed. Duplicate threads are not allowed here.

    Please note regarding your note of urgency in the closed thread: whilst I understand that you may be in a bit of a panic, don't tell us that it is urgent, please. All your helpers here are volunteers giving freely of their own time: you haven't paid a penny for any assistance you get here, therefore expecting any form of speedy response or preferential treatment, or seeming to, is inappropriate.

    Thank you for your understanding and patience.
    Moderator
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. Replies: 2
    Last Post: 06-29-2017, 11:31 AM
  2. [SOLVED] How do i change SourceData for all pivots in workbook while disconnect/connect slicers?
    By andygxxxv in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-04-2016, 10:15 AM
  3. Replies: 0
    Last Post: 10-18-2013, 11:35 AM
  4. Copy and Paste Pivots in each sheet of workbook
    By cesardaniel3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2013, 03:11 PM
  5. change source data for multiple pivots
    By gaevs75 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-09-2013, 06:17 AM
  6. VBA to Change Multiple Pivots' Filters According to a Reference Cell
    By a88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2012, 06:06 PM
  7. Multiple pivots with the same row - how do i make them change at the same time?
    By davellll in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-12-2009, 11:12 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1