I'd like to be able to double click on any part of a given row and open a new html page (based on specific cell value/content). Basically I have all NY counties, each in one row:
County - City - State
Manhatan - New York - NY
Brooklyn - New York - NY
Bronx - New York - NY
Westchester - New York - NY
etc.
I need to be able to get the cell value in the County column and use it to run a function. Example: if I double click on the first row, that should open a new html page about Manhattan. I tried some answers that were posted for a kind of similar question (about editing) but they didn't work.