Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Merge Files

  1. #1


    I have approx 20 files that I need to merge into 1. I'm trying to avoid cutting and pasting files 2 thru 20 into file #1. Is there a way to do this w/o using the cut and paste feature? Thanks.

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Denver, Colorado USA
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    Yes, it usually just requires a simple VBA macro to merge files. But to give any more specific information about how to do that would require knowing what you mean by "merge". Do you just want to transfer all the worksheets from the other workbooks into one workbook? Or perhaps you want to copy columns of data from worksheets in other workbooks to a particular destination in the source workbook? Or perhaps you want to check all worksbooks for the most recent information and consolidate all the most recent cell values into one workbook?
    Keep Excelling.


    VBAexpert Excel Consulting
    LinkedIn Profile
    AllExperts Profile

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts