Home |
Search |
Today's Posts |
#1
|
|||
|
|||
merge data from 2 Excel files
Hi,
I have 2 excel files (A.xls and B.xls) with some data. In one of them, i want to do the following task : - from file A.xls, look for value of column A, and check if exists in file B.xls - if yes, take value of column C from file B.xls, and write it in file A.xls (Column G) and this for all data of my column A from file A.xls. is it posible to use worksheet function for that ? thx, Maileen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how i can merge more than two excel files in one file. | New Users to Excel | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
How to sort/update large excel db | Excel Discussion (Misc queries) |