Find same row in another sheet

**ali84pk** · 07-04-2010, 09:57 AM

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.

**Simon Lloyd** · 07-04-2010, 03:31 PM

Your data isn't sufficiently different to do that, by which criteria should it search?

**davesexcel** · 07-04-2010, 03:35 PM

Check out this site
http://www.rondebruin.nl/find.htm#Color

I slightly modified the code to work with the double click

Please Login or Register  to view this content.

This worksheet code initiates the "Color_cells_In_Range_Or_Sheet" macro

Please Login or Register  to view this content.

I have been looking at it for too long trying to figure out why the "Time From" and "Time To" cannot be found in Sheet2.

Hopefully another set of eyes will help in solving this part.

**ali84pk** · 07-05-2010, 02:55 AM

Dear Simon and Davesexcel

Thanks for your reply.

Dear Simon, I highly appreciate your reply,it really helped me a lot to learn something more. I am not expert in VBA, therefore i need your little more efforts. I had Installed your VBA codes, it worked perfectly, and i found that searching criteria it the cell in which we double click, but I want the searching criteria that complete row in which we selected the cell.

I had attached one more sample with your installed VBA, if you click on "Amman" in sheet(1), it will highlight all "Amman" found rows in Sheet(2), where as I want to be highlighted, completely matching row in both sheets, (in other words, duplicate row in sheet(2) ).

Thanks