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

Thread: Merge Files

  1. #1
    Guest

    Default

     
    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
    Location
    Denver, Colorado USA
    Posts
    4,240
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

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
  •  

 

 
DMCA.com