Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merge and Sum Tables
Hi,
I have two tables which get created several times per month. I would like to be able to merge all entries in the two tables and i there are duplicate items in Col A then sum the value in Col B e.g Table 1: Supplier Weight Tim 5 Tom 7 Brad 3 Table 2: Supplier Weight John 4 Dave 3 Sarah 9 Tom 2 Merged Table: Supplier Weight Tim 5 Tom 9 Brad 3 John 4 Dave 3 Sarah 9 I have no problem using a macro or formula. thanks in advance, Hamis -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge data from two separate tables | Excel Worksheet Functions | |||
Merge data from two separate tables | Excel Discussion (Misc queries) | |||
how 2 merge 2 tables (worksheets) | Excel Discussion (Misc queries) | |||
HOW TO MERGE TWO TABLES | Excel Worksheet Functions | |||
Merge Pivot Tables | Excel Discussion (Misc queries) |