Dear Experts,
Iam looking for VBA to search row on based of selected cell in sheet1.
For example. I have some data in Sheet2, and in sheet1 also. What I want is, when I double click on any cell in sheet1, macro should search that entire row in sheet2 and color that row.
Example for structure of data is also attached.
Thanks in advance.
Bookmarks