On Sheet1, Column A:A, I have a long list of items. On Sheet1, Column B:B, I would like to mark if item in A:A has been chosen.
On Sheet2, it will be a picture/ button, when clicked, it will show a random item from Sheet1 A:A, where Sheet1 B:B is empty.
Thereafter Sheet1 B:B will be marked, so that the same item in Sheet1 A:A will not appear again.
Can any expert teach me how this can be written in Google script? Many thanks in advance.
Aucun commentaire:
Enregistrer un commentaire