yogi_Formula In Cell A5 To Pull Tasks By Name Specified In Cell A1 Of NAMEd Sheet Sorted By 'Completion On' Date

                  Google Spreadsheet   Post  #1783
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-06-2014
post by  Martin Holmstrom:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Qn56hCtkUPI)
Copy every row with a cell containing a name from one tab to another

Hi,

I'm working on a schedule for a group project and I would like to copy every row that has a persons name in one cell to another tab that only shows what tasks that person is assigned to.

Copy every row (the entire row from A:K) that has the name "Bob" in column C to the sheet tab called "Bob".

These are two things I would like to have but are not necessary:

It would be great if it could sort the results based on the deadline for the tasks.

If you could send data back to the main schedule that would also be great, like if someone changes the "Completed on:" cell it would update the main schedule.

Here is a link to a dummy copy of the schedule I'm working on: https://docs.google.com/spreadsheets/d/1EcFdSpPOWBn_C6noWJSd3jOYJSAIBNcH6lh7Bs4c6MQ/edit?usp=sharing

Thank you in advance

Sincerely,

Martin Holmstrom

-----------------------------------------------------------------------------------------------------------------------