I have a Google Spreadsheet.
In this one, I have two Worksheet (example: W1 and W2).
In W1 I have list of names and datas.
In W2 I have a single cell, which retrieves the name of the person (of course I could choose from a list every single name present in W1), and data retrieved always from W1 with graphs (depending on the person chosen from the list above).
My goal would be:
- being able to select, one by one, a different name
- save in a pdf certain cells from W2
- send that pdf to the email of the chosen person
Is it possible in some way?