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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Thedark15
 | Femeie
24 ani
Bacau
cauta Barbat
24 - 46 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
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 6 luni |
|