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: vio69 25 ani
 | Femeie 25 ani Botosani cauta Barbat 25 - 50 ani |
|
|
Mrrrr's Forum (VIEW ONLY)InregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 975
|
|
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
|
|
| |
|
| pus acum 2 saptamani#2 |
TRaPModerator
Postari: 975
|
|
Or you can do this without even saving the file if you want to list all sheets in the current workbook for some reason (e.g., use sheet names in INDIRECT function).
Simply do steps 1-3, copy/paste your sheet names where you need them, delete the formulas from 2 and the name in Name Manager.
|
|
| |
|