Hi,

I have a workbook in which there are around 10 sheets.

all the sheets have email address in it like [email protected].

I want to have a macro which should give me a box where i can enter the first part of email address ("abc" from above example) and it should take me to the sheet where the email address is and then it should give me the display of the sheet name.

One issue: If the same abc is there for multiple times, then it should give me the sheet names of the others also and then if i want to it should take me to that particular sheet.

Any help please.