Greetings,
I am creating a workbook to consolidate data from two other workbooks created by exporting reports from an accounting system. Here are examples from the two exported workbooks:
WORKBOOK A
<tbody>
</tbody>
WORKBOOK B
<tbody>
</tbody>
Here is the result I'm looking for:
WORKBOOK C
<tbody>
</tbody>
My first issue is that I need to have Workbook C take the ItemCode values from Workbook A and populate only the unique values. The second issue is that I will need Workbook C to populate those unique values and the SUMIF formulas used to give the totals per ItemCode for InvValue and InvTrans without having to open Workbooks A and B.
I look forward to learning the magic!
Justin
I am creating a workbook to consolidate data from two other workbooks created by exporting reports from an accounting system. Here are examples from the two exported workbooks:
WORKBOOK A
ItemCode | InvValue |
A | 0.00 |
A | 619.42 |
E | 3.00 |
G | 289.56 |
C | 4,459.33 |
C | 44.59 |
I | 153.40 |
J | 139.18 |
K | 56.88 |
H | 794.82 |
F | 650.37 |
B | 184.38 |
B | 368.76 |
D | 1027.71 |
D | 355.45 |
D | 543.19 |
<tbody>
</tbody>
WORKBOOK B
ItemCode | InvTrans |
A | -130.81 |
B | -420.15 |
C | -3,354.76 |
D | -1087.42 |
E | -12.50 |
F | -627.66 |
B | -512.21 |
G | -280.47 |
D | -621.80 |
H | -774.72 |
C | -524.67 |
I | -124.14 |
J | -130.99 |
A | -455.56 |
K | -54.45 |
Z | -15.24 |
<tbody>
</tbody>
Here is the result I'm looking for:
WORKBOOK C
ItemCode | InvValue | InvTrans |
A | 619.42 | -586.37 |
E | 3.00 | -12.50 |
G | 289.56 | -280.47 |
C | 4,503.92 | -3879.43 |
I | 153.40 | -124.14 |
J | 139.18 | -130.99 |
K | 56.88 | -54.45 |
H | 794.82 | -774.72 |
F | 650.37 | -627.66 |
B | 553.13 | -932.36 |
D | 1,926.35 | -1709.22 |
<tbody>
</tbody>
My first issue is that I need to have Workbook C take the ItemCode values from Workbook A and populate only the unique values. The second issue is that I will need Workbook C to populate those unique values and the SUMIF formulas used to give the totals per ItemCode for InvValue and InvTrans without having to open Workbooks A and B.
I look forward to learning the magic!
Justin