J
joekmoch
Situation: I have a master spreadsheet listing activities to be done
by a committee for an event. Some of the activities are specifically
related to a certain individual. I have those marked with an "x" in a
special column of the spreadsheet.
Problem: I'd like to create a second sheet just for that person with
only their marked tasks. Once created if the contents of a row with
the "x" is modified, I would like the modification to appear in this
second spreadsheet. Finally, it would be nice if there's a way to
update the second sheet either automatically or manually with a script
so that if a row on the master sheet is added, that row will appear in
the second sheet.
I did some digging in this forum and nothing like this popped out at
me, but I could have missed something. Thank you.
by a committee for an event. Some of the activities are specifically
related to a certain individual. I have those marked with an "x" in a
special column of the spreadsheet.
Problem: I'd like to create a second sheet just for that person with
only their marked tasks. Once created if the contents of a row with
the "x" is modified, I would like the modification to appear in this
second spreadsheet. Finally, it would be nice if there's a way to
update the second sheet either automatically or manually with a script
so that if a row on the master sheet is added, that row will appear in
the second sheet.
I did some digging in this forum and nothing like this popped out at
me, but I could have missed something. Thank you.