Merge Files

Feb 21st, 2002, 02:15 PM

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 · Feb 21st, 2002, 05:38 PM

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?

Feb 21st, 2002, 05:38 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	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 (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 02:15 PM	#1
Guest Posts: n/a	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.