Jump to cell after cell click or character entered

[MG312]

Hi, years ago I managed to do this but can’t seem to make it work now…

I’m using LibreOffice 7 and want to create a spreadsheet a bit like a flowchart.

So the user is presented with a question and can respond either yes or no (Maybe they could type Y or N, or click on a cell/button that contains Y or N)

When they select their answer I want the spreadsheet to show a new cell range somewhere else that contains information or instructions.

Is there a way to do this using IF - GOTO or other similar commands without using Macros? If not could you suggest a suitable Macro tutorial, please?

[schiavinatto]

Hi @MG312, here is a suggestion:

MG312_ask_en.ods (11.6 KB)

[joshua4]

Yes there is a way. Use HYPERLINK().

HYPERLINK("#TheSheet.$B$6","Yes") for single framed cell

You can link to entire ranges, and they will highlight as a selection (colored as opposed to just framed).

HYPERLINK("#TheSheet.$B$6:$B$6","Yes") for single highlighted cell
HYPERLINK("#TheSheet.$B$6:$C$8","Yes") for multiple highlighted cells

You can hand-enter entries like this and they will update themselves if you insert rows/columns, which is handy since you can keep a list neatly together. However, if there is any complexity to what you want to do with this then you may want to set it up as a database sheet and a UI sheet. For example, if you want to do some old-school text-game or self-teaching lesson set. With some planning, you can span sheets as well.

Here is an example that does not span sheets, but it does implement a data sheet. [To get random numbers, mark the complete range being used (here, Keys) then use Sheet>Fill Cells>Fill Random Number (you could have a repeat but it’s easy to edit if that happens). Of course, once you have random numbers in place and use those keys, you can add to them or delete them, but do not change them. No magic to random numbers, it’s just that after several edits any sequence will be messy, anyway.]

Notice, nothing more is done to the Survey sheet…all entries are done on the Data sheet. Of course, you would actually remake the Survey sheet per your needs, but for the example, it is complete.

HyperlinkSurvey.ods (11.9 KB)