Search a value in Column A and print other column values of the same row in other sheet

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

Hi, and welcome to the forum.

You don't necessarily need a macro. Standard Data Filtering will identify the results you want. Either by filtering the list in place or by copying the required filtered records to another sheet.

If you do want a macro then just adopt the approach above and code it. Try using the macro recorder for starters and then adjust it as necessary if the original data varies.

Hi

Do you still want a macro for this.. or is the prob solved?

OK.. then just tell me : everytime you search for a value from col A, do you want the sheet2 to be cleared ie. do you want the previous data to be deleted and the fresh search data to be displayed?
Do clear how you want the macro operation to be carried out.....

OK then... check this out:

navn.xlsm