hi,

I have two sheets in my excel workbook.
my need is if i select one cell in my sheet and if i click the button that string in the selected cell has to be searched in the next sheet[coumn B] and if the string found then the same row of C column i need text as "True" of second sheet.

please show me some sample macro code to do this please