Merging Data from Separate Tables

Hi all,

Just have a quick question. I have multiple data tables in which I want to combine into one table. However, some tables have replicate names, and I want to combine those names into one cell with the sum of the values from all the tables.

Perhaps the graphic below will explain it better...trying to the get to the table named "Final" from the other two tables.

Is there any way to do this? Does this get trickier with three or four tables?
Thanks!

I would use Access to do this. However, if that is not available to you, then you may want to consider using MS Query which is part of Excel.

Here is a short tutorial that will get you started.

http://www.exceluser.com/explore/msquery1_1.htm

If you go this route and get stuck, post your questions in the Access forum section.

Alan