Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging Data from Workbooks | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Excel: how to merge data from 2 workbooks with 1 col. in common? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |