Hello dear helpfull mrexcel friends..i need help please. very important .thanks
i have two excel file for dictionary. Both are for two languages . both are with columns. word and meaning. but one language of two dictionaries is same. for example i have English-kurdish and kurdis-persian files. i want make make persian english new dictionary with same rows in kurdish. i pasted their columns side to side as: Eng-Kur is column A and B , Kurdish-Persian column is C and D so i want merging or bringing same rows in kurdish (column B-C) in one row.
example
my Eng-Kurdish data as below:
<colgroup><col><col></colgroup><tbody>
</tbody>
my kurdish-Persian data as below:
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
i pasted two file side by side in one file as ABCD columns as below:
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
i want macro code to rearrange and bring only same rows with two columns near to eachother in new columns as below:
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
then i will delete kurdish columns and make ENG-PERS dictionary
please give me a way to arrive this solution. macro please. very very thanks..
i have two excel file for dictionary. Both are for two languages . both are with columns. word and meaning. but one language of two dictionaries is same. for example i have English-kurdish and kurdis-persian files. i want make make persian english new dictionary with same rows in kurdish. i pasted their columns side to side as: Eng-Kur is column A and B , Kurdish-Persian column is C and D so i want merging or bringing same rows in kurdish (column B-C) in one row.
example
my Eng-Kurdish data as below:
ENG | KU |
book | pirtûk |
table | mase |
tree | dar |
<colgroup><col><col></colgroup><tbody>
</tbody>
my kurdish-Persian data as below:
KUR | PERS |
dar | dirext |
sar | serd |
pirtûk | ketab |
mase | miz |
zêr | zer |
mêr | merd |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
i pasted two file side by side in one file as ABCD columns as below:
ENG | KU | KU | PERS |
book | pirtûk | dar | dirext |
table | mase | sar | serd |
tree | dar | pirtûk | ketab |
mase | miz | ||
zêr | zer | ||
mêr | merd |
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
i want macro code to rearrange and bring only same rows with two columns near to eachother in new columns as below:
ENG | KU | KU | PERS |
book | pirtûk | pirtûk | ketab |
table | mase | mase | miz |
tree | dar | dar | dirext |
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
then i will delete kurdish columns and make ENG-PERS dictionary
please give me a way to arrive this solution. macro please. very very thanks..