Hi All,
I have a workbook with 3 sheets each having 2 columns!
Now i need to search in all 3 sheets, if column A value of one sheet matches with another sheet, then i need to sum the values in column B. if it doesnot matches then i just need take those values and put it in my resultant sheet.
so the result from the above example will be as below:
Since here the first value in column A of sheet 1 matches with that of sheet 2, the values in column B is summed up.. all other values are placed as it is..
Thank you,
I have a workbook with 3 sheets each having 2 columns!
Rich (BB code):
Sheet1:
Col-A</SPAN> Col-B</SPAN> 3245688</SPAN> 12</SPAN> 4567893</SPAN> 13.5</SPAN> 1342567</SPAN> 15</SPAN>
<TBODY>
</TBODY><COLGROUP><COL span=2></COLGROUP>
Sheet2:
Col-A Col-B 3245688 13.7 2139475 45 9875768 23
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>
</TBODY>
Sheet3:
Col-A Col-B 142234 23 24563 56 156789 13.2
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>
</TBODY>Now i need to search in all 3 sheets, if column A value of one sheet matches with another sheet, then i need to sum the values in column B. if it doesnot matches then i just need take those values and put it in my resultant sheet.
so the result from the above example will be as below:
Rich (BB code):
Col-A Col-B 3245688 25.7 4567893 13.5 1342567 15 2139475 45 9875768 23 142234 23 24563 56 156789 13.2
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>
</TBODY>Thank you,
