Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
MicheleC
 | Femeie
25 ani
cauta Barbat
26 - 68 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 961
|
|
Note: The file will have to be saved as Macro-Enabled file, even if no VBA is actually written in it.
1. Create a Defined Name (Formulas - Define Name) named SheetNames: =GET.WORKBOOK(1)&T(NOW())
2. In the desired TOC sheet, preferably the first sheet from left to right, put this in cell A2 (A2 so the formula will skip the first sheet): =IFERROR(INDEX(MID(SheetNames;FIND("]";SheetNames)+1;255);ROW());"")
3. Drag formula in cell A2 down for as long as no blanks are shown. You can go maybe 50 rows, so you are sure it will add any new sheet to the list.
That will display the name of the sheet.
4. In cell B2 add the following formula then drag down: =IF(A2<>"";HYPERLINK("#'" & A2 & "'!A1";"Go to sheet " & A2);"")
Source: ChatGPT
|
|
| |
|
