Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 53
  • Last Modified:

Excel: Auto - merging two tables on two seperate worksheets

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.
0
Wonderwall99
Asked:
Wonderwall99
  • 2
2 Solutions
 
Subodh Tiwari (Neeraj)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.
0
 
ProfessorJimJamCommented:
i think you can achieve that by using tables connection. please see a video i recorded for a similar question previously.

https://www.youtube.com/watch?v=VcEh8KX1SRc
1
 
ProfessorJimJamCommented:
Question is abandoned and closed as follows
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now