Rakesh Kumar
New Member
- Joined
- Apr 26, 2015
- Messages
- 7
Please help me any genious!!!
i have two excel one is file.xlsx and other is data.xlsx data is on sheet 1 on both the excels from R1:C1
like this:-
File.xlsx
<tbody>
</tbody>
Data.xlsx
<tbody>
</tbody>
i have to find the exact match from data.xls in file.excel and the output will be after running macro on file.xlsx is like this:-
Output result:-
File.xlsx
<tbody>
</tbody>
Please note that search the term from data.xlsx in File.xlsx and output is on file.xlsx
Need Help for implimenting this macro!!!
Really Different.......... and difficult
i have two excel one is file.xlsx and other is data.xlsx data is on sheet 1 on both the excels from R1:C1
like this:-
File.xlsx
R1 | Travel to United states of America and meet St. Martin | |
R2 | St. martin is a person name | |
R3 | Office having Information Technology Department | |
R4 | Go to the human research and development department | |
R5 | The treatment is FREE in the Hospital |
<tbody>
</tbody>
Data.xlsx
R1 | United states of America | A country Name |
R2 | St. martin | Name of person |
R3 | Information Technology Department | Official |
R4 | Human research and development | Medical Departments |
R5 | treatment | health fitness related |
<tbody>
</tbody>
i have to find the exact match from data.xls in file.excel and the output will be after running macro on file.xlsx is like this:-
Output result:-
File.xlsx
R1 | Travel to United states of America and meet St. Martin | United states of America > A country Name St. martin > Name of person |
R2 | St. martin is a person name | St. martin > Name of person |
R3 | Office having Information Technology Department | Information Technology Department > Official |
R4 | Go to the human research and development department | Human research and development > Medical Departments |
R5 | The treatment is FREE in the Hospital | treatment > health fitness related |
<tbody>
</tbody>
Please note that search the term from data.xlsx in File.xlsx and output is on file.xlsx
Need Help for implimenting this macro!!!
Really Different.......... and difficult