+ Reply to Thread
Results 1 to 1 of 1

Macro to paste the sheets on different workbooks

  1. #1
    Forum Contributor
    Join Date
    04-03-2021
    Location
    Zaragoza
    MS-Off Ver
    2102 MICROSOFT 365
    Posts
    125

    Macro to paste the sheets on different workbooks

    Good morning,

    I would like to know how to automate one of my daily tasks.

    I have to run the report I am attaching and then split it into the different locations. Id like to use a macro that does the pivot table for me, split the data into the different locations as per the sheet "pivot" in the attachment and then put the new sheets with the locations names in different workbooks so that there is a workbook per each location.

    Thank you
    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. [SOLVED] Copy range of data from all workbooks in folder and paste to multiple sheets in new book
    By Brontosaurus in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2019, 08:52 AM
  2. VBA: Fetch workbooks from file path; paste to sheets in active workbook
    By ahazeldene in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2019, 03:03 PM
  3. Copy Paste to visible cells only with different filters in different sheets / workbooks
    By EhcacommenceVBAhum in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2017, 08:17 PM
  4. Replies: 14
    Last Post: 01-17-2014, 12:23 PM
  5. [SOLVED] Macro to Saving Workbook Sheets as Separate Macro-Enabled Workbooks
    By puppetpalace in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2013, 01:58 PM
  6. Copy Paste Data across Workbooks with multiple sheets & Referencing.
    By v999 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2012, 09:16 AM
  7. Copy paste sheets between workbooks
    By thisandthat in forum Excel General
    Replies: 3
    Last Post: 05-28-2011, 02:33 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1