Google Sheets:

I have data validation list in cell A1.The drop down menu has values a,b,c.

I want links to each of them to a specific cell, like user selects "a" from the drop-down and it goes to cell a5, b goes to cell c44 and so on...

What I need:
**Scripts that can very fast.

Please please help.

CodePudding user response：

It could be something like this:

function onEdit(e) {
  var ss = e.source;
  var name = ss.getActiveSheet().getName();
  if (name != 'Sheet1') return;

  var col = e.range.columnStart;
  var row = e.range.rowStart;
  if (col != 1 && row != 1) return;

  var sheet = ss.getSheetByName('Sheet1');
  var value = e.value;

  switch (value) {
    case ('Place 1'): sheet.getRange('c1').activate(); break;
    case ('Place 2'): sheet.getRange('c2').activate(); break;
    case ('Place 3'): sheet.getRange('c3').activate(); break;
  }
}

Here is the