+ 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
    57

    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)

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