+ Reply to Thread
Results 1 to 1 of 1

Copy data from Pivot to Static Table

  1. #1
    Registered User
    Join Date
    12-14-2018
    Location
    Staffordshire, England
    MS-Off Ver
    365
    Posts
    60

    Copy data from Pivot to Static Table

    Hi All,

    I currently have the task of automating a process which is currently completed entirely manually by basically doing copy & paste.

    Each month we receive a file (Source Data on my test file attached as an example) for which I plan to now import using Power Query and locate this file on a SharePoint site. From this a pivot is then created (Pivot on the attached) to in short take a sum of values for that current month. The source data would change each month and naturally so would the pivot and so this is why a static table is also in use to copy / paste that month's values from the pivot and so on. Ultimately this table is then used to produce graphs etc.

    Is it possible to do something with maybe VBA that could each month take the values from the current pivot or source data and add them to the table? There is no matching element in the source data in terms of Month / Year and so it literally just is that data at that moment in time which would populate.

    Hope all that makes sense?

    Thanks,
    Gaz
    Attached Files Attached Files

+ 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. 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. Macro to Copy Pivot Table and Paste a Regular Data Table in the Same Position
    By webfeet2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2013, 06:34 AM
  3. Need help with static names in data pivot
    By abaker9 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-19-2012, 04:52 PM
  4. Linking static notes with pivot table
    By boooinky in forum Excel General
    Replies: 1
    Last Post: 03-06-2012, 11:42 PM
  5. Dynamically associating static data to pivot table.
    By Folshot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2011, 04:47 PM
  6. formula to pull pivot data into static report
    By travelguy_73 in forum Excel General
    Replies: 2
    Last Post: 06-21-2008, 04:07 PM
  7. Making a pivot table report static.
    By ideal in forum Excel General
    Replies: 1
    Last Post: 02-28-2006, 01:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1