Merge Files

[Guest]

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.

 

[Damon Ostrander]

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?