I need to make cells within one column of a straight table function as links to another sheet in the document. For example, the dashboard shows a straight table with KPI's in one column and % attainment in another. Each KPI is a row in the table. I need to inlcude another column in the table where each cell in the column is functionally a "button" that if selected will take you to a different sheet in the document (where you can find more detail on the KPI for example.)
Using slight of hand, I can superimpose a transparent button over the cell, with the button action taking you to the proper sheet. The downside is that if you later move the table on its sheet, the button is set adrift and invisible.
Qv has to have a more elegant solution - I just can't figure out what it is.
