Hello Maciec,
Aha. Many sheets!
A slight change of plan then.
In your "Index" sheet, I'll assume that Column A, not just cell A1, will be used for the name changing purposes. As you need to transfer those names as required to cell B12 of each sheet, then use the same formula in B12 for each sheet but referencing consecutive cells in Column A of the "Index" sheet.
So, for Sheet1, the formula in B12 should be :=
=Index!A1
for Sheet3 (Sheet2 is the "Index" sheet):-
=Index!A2
for Sheet4:-
=Index!A3
etc., etc. etc.....
An easier way to do this for each sheet:-
In B12 of Sheet1, place the equals (=) symbol then go to the "Index" sheet and click on cell A1 (it will high-light with "marching ants) and hit Enter. The formula will then appear in Sheet1, B12. Do the same for Sheet3, Sheet4 etc..............
Now, place the following code in the "Index" sheet module as previously explained:-
Thus, each time a name is changed in any cell in Column A of the "Index" sheet, the relevant tab will be re-named. I've attached an updated test work book to show you how it works. There are a few notes for you in the test work book.
Bookmarks