VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,232
Hello Message Board,
From very long duration, Come back again to post the query. I hope everyone do well. okk..
I have written my code in Workbook 3.
In Workbook 2 I have multiple row repeated data in column A. example of data..
table abc pqr xzy
qwe chair poi lkjhgfdd ert
bhg fgdtrs table kjl re wwww
poi lkj dfg sdf chair
dfg fan asd
fan iu opi
In Workbook 1 I have master data.
Column A.....Column B
Table...........Lamp
Chair...........Man
Fan.............Air
Now, my query is..
Based on book 1 value, it find the values in Col A of Work book 2. Once the record finds, it paste the corresponding value in Col B of Workbook 2.
Example,
"Table" (cell A2) copy. go to book 2. finds all the "Table" in Col A. and paste "Lamp" (cell B2) value in front of
"table abc pqr xzy"
"bhg fgdtrs table kjl re wwww".
I hope I have clear my question.
I have did my code, but it finds only one record. I'm unable to do for find value one at a time all and paste value one at a time.
Please help me to get the code please.
From very long duration, Come back again to post the query. I hope everyone do well. okk..
I have written my code in Workbook 3.
In Workbook 2 I have multiple row repeated data in column A. example of data..
table abc pqr xzy
qwe chair poi lkjhgfdd ert
bhg fgdtrs table kjl re wwww
poi lkj dfg sdf chair
dfg fan asd
fan iu opi
In Workbook 1 I have master data.
Column A.....Column B
Table...........Lamp
Chair...........Man
Fan.............Air
Now, my query is..
Based on book 1 value, it find the values in Col A of Work book 2. Once the record finds, it paste the corresponding value in Col B of Workbook 2.
Example,
"Table" (cell A2) copy. go to book 2. finds all the "Table" in Col A. and paste "Lamp" (cell B2) value in front of
"table abc pqr xzy"
"bhg fgdtrs table kjl re wwww".
I hope I have clear my question.
I have did my code, but it finds only one record. I'm unable to do for find value one at a time all and paste value one at a time.
Please help me to get the code please.