Excel: Auto - merging two tables on two seperate worksheets


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.
Who is Participating?
ProfessorJimJamConnect With a Mentor Commented:
i think you can achieve that by using tables connection. please see a video i recorded for a similar question previously.

Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
If you are using Excel 2010 and later and both the sheets have the same layout, you may consider Power Query (A free Add-In by MS) to merge both the sheets into one master sheet.
Question is abandoned and closed as follows
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.