<div>
You can take a look at my article and adjust the code there to suite your needs:<br />
<br />
<a href="http://www.excel-user.com/2009/10/vba-combine-sheets-data-into-one-sheet.html" rel="ugc">http://www.excel-user.com/2009/10/vba-combine-sheets-data-into-one-sheet.html</a><br />
<br />
jppinto
</div>


You can take a look at my article and adjust the code there to suite your needs:

http://www.excel-user.com/2009/10/vba-combine-sheets-data-into-one-sheet.html [http://www.excel-user.com/2009/10/vba-combine-sheets-data-into-one-sheet.html]

jppinto

<div>
Thank you, and I was pleased to help you.<br />
.... Thinkpads_User
</div>


Thank you, and I was pleased to help you.
.... Thinkpads_User

<div>
<div class="content wysiwyg-content">
I have 42 files with 1 sheet each and I'd like to merge them into 1 file. Is there an easy way?
</div>
</div>


I have 42 files with 1 sheet each and I'd like to merge them into 1 file. Is there an easy way?

merge multiple excel files sheets into single file: excel 07

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.