samedi 24 avril 2021

Copying certain rows to duplicated sheet using macro

I've got a google sheet which I'm using as a monthly handover sheet with a to-do list at the bottom.

The to-do list has a checkbox then a couple of columns of information (a date, the task and who it's assigned to)

To-Do List

I've created a button that runs a macro to duplicate the sheet to create a copied sheet at the end of the month.

I'd like to copy over any tasks in the to-do list which haven't been 'ticked' as completed but I'm not very good at logic in google apps script.

Could anyone help me write the if statement to either copy unticked rows to the duplicated sheet or do duplicate all rows then delete the ticked ones.

Thanks, Joe

Aucun commentaire:

Enregistrer un commentaire