Hi all, what I need seems to be stupid to do with a vba code but I didn't find it here yet.
I have a big .xls file with about 1000 tabs, in the cell E2 I have a range of text values, each of these values has the exact name as existing tabs in my file and I would like to create automatically hyperlinks for the range of cell value I have to point their related tabs (for inst. cell E2 has Book as value and I want an hyperlink that points to the tab Book).
Is it possible to have a code to make this automatically for all values of the cell E2 and for all related tabs?
Thanks in advance.
I have a big .xls file with about 1000 tabs, in the cell E2 I have a range of text values, each of these values has the exact name as existing tabs in my file and I would like to create automatically hyperlinks for the range of cell value I have to point their related tabs (for inst. cell E2 has Book as value and I want an hyperlink that points to the tab Book).
Is it possible to have a code to make this automatically for all values of the cell E2 and for all related tabs?
Thanks in advance.