+ Reply to Thread
Results 1 to 2 of 2

Have many workbooks, each with many sheets. copy/past 2 col from each sheet to new book

  1. #1
    Registered User
    Join Date
    05-02-2020
    Location
    Chicago
    MS-Off Ver
    MS 10
    Posts
    1

    Have many workbooks, each with many sheets. copy/past 2 col from each sheet to new book

    Hello,
    This is my first post here.

    I have many workbooks, each with various number of sheets.
    Each sheet has two columns I need to cut and paste into a new workbook.

    I need to append each new cut and paste to the bottom of each old cut and paste. So I am basically stacking the data from the sheets into this new workbook.

    Is this possible?

    I appreciate any advise.

    I have read that I should load my books for people to help me, but my work has told me the data is proprietary, so that would be a big violation I can not do. I am hoping there may be a general formula I can utilize and adapt. A template of sorts.

    To recap: I have Workbooks 1,2,3,4,...n
    Each workbook has sheets, 11,12,13,...1n
    each of those sheets has two columns (A,B) that I need to cut and paste into a new workbook.

    So the new workbook would have one sheet that had all that new info and it may look something like this:

    11A, 11B
    12A, 12B
    1nA, 1nB
    2nA, 2nB

    Thank you

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Have many workbooks, each with many sheets. copy/past 2 col from each sheet to new boo

    You can load your data to Power Query and append each table to the other. Without a sample, you will need to search on "Power Query Append Sheets"
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Copy past sheets from the work book as it is
    By hudson andrew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2017, 01:53 PM
  3. Macro to copy past sheets from different workbooks
    By Andre2016 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2016, 10:27 AM
  4. copy and past rows on multiple sheets into master sheet
    By asqw in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-13-2014, 06:59 AM
  5. copy and past cell from multiple sheets into master sheet
    By asqw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2014, 07:10 AM
  6. copy and past cell on multiple sheets into master sheet
    By asqw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2014, 07:09 AM
  7. Vba Excel, Need to copy Sheets and past one line below main sheet.
    By dmcovey1993 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2013, 01:20 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