Google-sheets – way to copy text from two cells into another spreadsheet only if another cell has a YES

There is no real way if linking to a cell in Google Spreadsheets (I'm trying to build one using HTTP GET, but I'm stuck right now), but you can use a little trick I've found here.

Insert/Comment at a specific cell, and, in that comment "plus someone" - that is, type "+" and then the person's email or name NOTE: you will get a list of people in your domain as soon as you type the "+", filtered as you start typing their name/email the person you "plussed" will get an email with both the contents of the cell and your comment the link in that email will take them DIRECTLY TO THE TARGET CELL with the comment activated.

Add the person you want to send the link to, or yourself to get the link.

Copy of a Comment by Alexander Taylor Oct 27 '15 at 22:34 :

i notice that it only happens when cells contain newlines and possibly other special characters. adding the quotes might be done by the program you paste into -- each program may have the ability to convert tabular data into non tabular data as it wishes. if i paste into Google Keep, i see no quotes, but if i paste into my text editor, i get quotes. perhaps you can try first pasting into Google Keep, then copy again, and paste into destination program.