Solved

Excel:  Auto - merging two tables on two seperate worksheets

Posted on 2016-08-30
3
49 Views
Last Modified: 2016-09-18
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
Comment
Question by:Wonderwall99
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 30

Assisted Solution

by:Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj) earned 250 total points (awarded by participants)
ID: 41777053
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
 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 250 total points (awarded by participants)
ID: 41777125
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
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 41803586
Question is abandoned and closed as follows
0

Featured Post

Independent Software Vendors: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question