Home |
Search |
Today's Posts |
#1
|
|||
|
|||
exchange data between two files
Hi there;
first time here. I have two excel files: 1.xls and 2.xls In 1.xls, there are 2 columns and 1000 rows. column A are English words, column B are explaining about that words. File 2.xls, have 2 columns, column A have same words as column A in 1.xls file but not with same order, column B are blank yet. Now question is how can I manage to do this: Click on (2.xls file, Col. B, Row 30) then the explanation of the word appears there, in other words, the equation or macro should find similar word in 2.xls col B, Row 30 in file 1.xls and then copy its explanation and paste it in 2.xls, Col B, Row 30. Thanks for yoru help. Best Darius |
#2
|
|||
|
|||
In cell B30, enter:
=VLOOKUP(A30,[File1.xls]Sheet1!$A$1:$B$1000,2,FALSE) or similar formula. Copy up/down to suit. -- Vasant "Darius" wrote in message ... Hi there; first time here. I have two excel files: 1.xls and 2.xls In 1.xls, there are 2 columns and 1000 rows. column A are English words, column B are explaining about that words. File 2.xls, have 2 columns, column A have same words as column A in 1.xls file but not with same order, column B are blank yet. Now question is how can I manage to do this: Click on (2.xls file, Col. B, Row 30) then the explanation of the word appears there, in other words, the equation or macro should find similar word in 2.xls col B, Row 30 in file 1.xls and then copy its explanation and paste it in 2.xls, Col B, Row 30. Thanks for yoru help. Best Darius |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
merge data from 2 Excel files | Excel Worksheet Functions | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) |