<div>
Question is abandoned and closed as follows
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have two separate tables, each on a separate worksheet that I need to merge into a combined table on a separate worksheet. &nbsp;Is there a way to do this without manually combining the two? &nbsp;I'm looking for a solution that doesn't involve VBA.
</div>
</div>


Hi,

I have two separate tables, each on a separate worksheet that I need to merge into a combined table on a separate worksheet.  Is there a way to do this without manually combining the two?  I'm looking for a solution that doesn't involve VBA.

Excel:  Auto - merging two tables on two seperate worksheets

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