Find name of sheet where string exists in workbook

[Samadhan Gaikwad]

I have values in a column. I want to find the name of sheet where value is present. I have altogether 6 sheets where value exists in only one of the 6 sheets.
Thank you in advance.

 

[Marc L]

Just use the regular Excel inner search …​

 

[NARAYANK991]

Hi ,

See if this link is helpful :

https://www.mrexcel.com/forum/excel...across-multiple-sheets-return-sheet-name.html

Narayan