ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I want to merge data from 2 different workbooks (https://www.excelbanter.com/excel-worksheet-functions/114310-i-want-merge-data-2-different-workbooks.html)

Shin

I want to merge data from 2 different workbooks
 
Hi All

I have 2 workbooks (workbook 1 and workbook 2) which both have data in sheet
1 respectively. The column heading are the same in both workbooks as follows
Org, Number and Percentage.

Under Org column a organisation can only appear once however this is not
compulsory and it can appear in workbook 1 and not in workbook 2 also vice
versa.

The data will always appear in these columns. What I want to be able to do
is to merge all the data from workbook 2 and bring it into workbook 1. Where
their is a match eg. wrkbk 1 BT has 5 and wrkbk 2 BT has 10 this merge now
shows BT has 15.

I hope I have not missed anything, please do ask if I have....

Kind Regards



All times are GMT +1. The time now is 03:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com