Hi All,
I am a novice with using VBA code and trying to find a solution for my work since past one week. And the problem, to search a value in Coulmn A of Sheet1 and print the value of the another column of the corresponding row in another sheet say Sheet2. Note that the value appears more than one time in the coulmn A and required to print all the corrsponding column values in sheet2.
Ex: A B C
1R 3R 4T
2R R5 45
1R 4T R4
1C 4R T6
1R 5T 45R
2R 4R 4R
1C 3R 3E
If i the search value is 1R then the result in other sheet would be like
3R 4T
4T R4
5T 45R
Thanks for your help in advance.
Regards,
Naveen
Bookmarks