Get sheet name that it have the name in column A

[MOUNIR75]

Hello,
please i need your help

Can I have beside each name the name of the sheet it belongs to.

Thank you

 

[MOUNIR75]

Yes you can, but the best way to do it will depend on the sheet names you want to search in. What are the names of the sheets you want to search?

hello,
sheets 1,2,3
and i want to add other sheets later
thank you

 

[myall_blues]

At the moment, it works for any sheet name except ‘Main’. If you add more sheets with any name other than ‘Main’ it will work for those too. Does that do what you want?