There were somehow related questions earlier. One I found again was this one in the German branch.
Despite the fact that already an accepted answer exists, I add an example going different ways. That’s becasuse I wouodn’t like to need to define a potenially infinite number of named ranges, and to add new named ranges probably again and again.
If I understood the situation correctly, there are ways to solve the task using th HYPERLINK() function without needing any specific measures per “item type”. One of these ways can use a dedicated sheet containing a complete list of these types, and using an adjacent column to get links very similar to bookmarks automatically. Another way accepts the input of one of the “types” into a specific cell supported by a ‘Validity’ setting if wanted. Both these solutions are demonstrated in the attached demo. The maintenance of the “bookmark-solution” may suffer from problems caused by a bug or by general shortcomings of HYPERLINK.
There is also demonstrated a solution based on user code whitch should be even more comfortable, but comes with the general disadvantages of relying on “macros”. Ths solution can, of course, only work if macros are permitted or if the needed code is moved to the local ‘Standard’ library.
You find the demonstrating file here.
