Check/Tick all rows with same data

[unpronounciable]

Hi everyone!

So let's say I have a table like this:

Apple
Banana
Cherry
Banana
Durian

And when I tick one row:

Apple
Banana	✓
Cherry
Banana
Durian

The rest of rows of same values will also be ticked:

Apple
Banana	✓
Cherry
Banana	✓
Durian

I would like to have the macro/VBA for this.

This question was also posted at:
Ozgrid: http://www.ozgrid.com/forum/showthread.php?t=176536
MrExcel: http://www.mrexcel.com/forum/excel-q...same-data.html

Thank you very very much for your time!

[jraj1106]

Hi

Try this :

searchdata.xlsm