Notifications
Clear all
Topic starter
Hi Team,
I will require to list the sheets by using {=@INDEX(ListSheets,1)}.
That is working in some files and but not all the time. Please see the one not working.
where do I have to check it too.
thank you.
Regards,
Aye
Posted : 11/08/2021 8:41 am
Hi Aye,
The formula is referring to a name ListSheets except there is no name set up in that file, which is why you're getting an error! See this tutorial on how to list sheet names.
Mynda
Posted : 12/08/2021 3:41 am
Topic starter
Many thanks, Mynda.
The video is better than what I required.
Much appreciated.
Regards,
Aye
Posted : 13/08/2021 4:34 am