Macro, or formula to jump to a defined cell

English
, , , ,
#1

I am a reloader(cartridge) and have made a whole spread sheet of weight and powder needed, I’m looking to see if there’s a way i could encode a box, macro or a specific formula to jump to a specific cell.
Example: Open the document, Up top i see a couple cells, one of them is labeled “9mm Vihtavuori” I click on said cell and it send me to Cell: A3866
which is where the applicable information is at.

Is there any way to do this? I’m trying/ working on making this document for me and my family, and would like to try to make it easy to use for them, as well as for my self.
Thank you!

#2

Why A3866 and not A3865 or A3867 or A1?

#3

Because at Cell A3866 is where the information is that i want to jump to.

#4

=HYPERLINK("#A3866") and make sure that you never insert new rows, delete rows or apply any sort order to that list, so the required information is always guaranteed to be in A3866.

#5

Beautiful, Thank you ill give it a test right now!

#6

Now to play with it some more but i do appreciate it!
I need to figure out how to name that cell

#7

To allow the “defined cell” to be defined by a match instead of needing to be defined by an address there can be implemented more flexibility.
See the attached example (ask109384_LinkToFirstLastCellWithSpecificContent.ods) (64.1 KB)

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.