function onEdit(event){
  var sheet = event.source.getActiveSheet();
  var editedCell = sheet.getActiveCell();

  var columnToSortHaveBlorps = 2;
  var haveTableRange = "B2:D300";

  if(editedCell.getColumn() == columnToSortHaveBlorps){
    var range = sheet.getRange(haveTableRange);
    range.sort( { column : columnToSortHaveBlorps } );
  }

  var columnToSortWantBlorps = 1;
  var wantTableRange = "A2:A300";

  if(editedCell.getColumn() == columnToSortWantBlorps){
    var range = sheet.getRange(wantTableRange);
    range.sort( { column : columnToSortWantBlorps } );
  }
}