I made a Google Form for assigning a task to myself or a colleague.
spreadsheet name: Science, Column 1=Name 2=task 3=due date
spreadsheet name: Mathematics, Column 1=Name 2=task 3=due date
What I need to do is search each spreadsheet (that these forms create) for my name. Then copy the whole row that my name is on so i have all my tasks in one place without having to keep opening every spreadsheet and looking for my name.