Spreadsheet: 210812d1359567469-really-need-help-please-automation-across-sheets-sample-excel
Sheet: GUEST LIST NAMES

 | INDUCTION GUEST LIST TRACK SHEET
 |  |  |  |  |  | TRACKING:
 |  |  |  |  |  | Confirmed | C
 |  |  |  |  |  | Declined | D
 |  |  |  |  |  | Pending | I
 |  |  |  |  |  | Not yet invited | N
 |  |  |  |  |  | Total Required Attendees
 | Date Hired |  | Status ('I'/ 'C'/ 'D') | Prefix ("Mr." / "Ms.") | Surname | First Name | Nickname | Position | Division | Assignment
1 | 2012-10-16 00:00:00 |  | I | Mr. | Abanco | Rafael |  | Nutrition Specialist | N Infant Nutrition | MAO
2 | 2012-06-21 00:00:00 |  | I | Ms. | Abantao | [NAME] | Mabs | Nutrition Specialist | N Infant Nutrition | MAO
3 | 2012-10-16 00:00:00 |  | C | Ms. | Abodeso | [NAME] | [NAME] | QA Specialist | Technical | CF
4 | 2012-11-16 00:00:00 |  | C | Mr. | [NAME] | [NAME] | Jujoy | Logistics Specialist- DC Outbound | Supply Chain Management | SDC
8 | 2011-10-10 00:00:00 |  | C | Ms. | Alilio | Marienel |  | Nutrition Specialist | N Infant Nutrition | MAO
6 | 2011-01-31 00:00:00 |  | C | Mr. | Almazan | [NAME] | Boj | Distributor Operations Executive | Grocery Sales | MAO
5 | 2012-09-17 00:00:00 |  | D | Mr. | Andal | Dennies | Dennies | Factory Automation Specialist | Technical | CF
9 | 2012-11-05 00:00:00 |  | C | Ms. | Arsenio | Katrina | [NAME] | HealthCare Key Accounts Specialist | N Health Science | MAO
10 | 2012-06-18 00:00:00 |  | I | Ms. | Bañares | [NAME] | Jhoi | Administrative Specialist - DHNS | DHNS | MAO
7 | 2012-11-16 00:00:00 |  | D | Ms. | Bardaje | [NAME] | [NAME] | Demand and Supply Planning Specialist | Supply Chain Management | CDO
11 | 2012-11-16 00:00:00 |  | C | Ms. | Bendigosa | [NAME] |  | Nutrition Specialist | N Infant Nutrition | MAO
12 | 2012-11-16 00:00:00 |  | C | Ms. | Branzuela | [NAME] |  | Nutrition Specialist | N Infant Nutrition | MAO
13 | 2011-12-08 00:00:00 |  | D | Ms. | [NAME] | Glemhier |  | Nutrition Specialist | N Infant Nutrition | MAO
14 | 2012-06-01 00:00:00 |  | C | Mr. | Cayamanda | [NAME] | Rich | Operation Performance Engineer | Technical | CDO
57 | 2011-10-10 00:00:00 |  | C | Mr. | Cena | [NAME] |  | Nutrition Specialist | N Infant Nutrition | MAO
 | 2012-08-01 00:00:00 |  | C | Mr. | Claravall | [NAME] |  | Production Supervisor | Technical | CDO
 | 2012-06-29 00:00:00 |  | I | Ms. | Corsame | [NAME] | Tin | Order Management Specialist | Supply Chain Management | MAO
 | 2011-10-10 00:00:00 |  | D | Ms. | Cruz | [NAME] |  | Nutrition Specialist | N Infant Nutrition | MAO
 | 2011-10-10 00:00:00 |  | I | Ms. | [NAME] | Ma. [NAME] |  | Nutrition Specialist | N Infant Nutrition | MAO
 | 2011-07-01 00:00:00 |  | C | Ms. | [NAME] | Amelia | [NAME] | Financial Accounting Services Head | Finance and Control | MAO
 | 2011-09-19 00:00:00 |  | C | Ms. | [NAME] | May |  | Nutrition Specialist | N Infant Nutrition | MAO
 | 2012-03-16 00:00:00 |  | C | Ms. | Dolz | Glaiza |  | Nutrition Specialist | N Infant Nutrition | MAO
 | 2012-12-03 00:00:00 |  | I | Mr. | Dueñas | [NAME] | Miko | Production Supervisor-Coffee | Technical | MAO
 | 2012-11-05 00:00:00 |  | I | Ms. | Dumaguin | Michelle | Mich | Operations Performance Engineer | Technical | CDO
 | 2012-10-16 00:00:00 |  | C | Mr. | Dumpor | [NAME] | Mar | Operations Performance Engineer | Technical | TF
 | 2012-10-16 00:00:00 |  | D | Ms. | Ferrer | [NAME] | [NAME] | Logistics Specialist- Costing and Finance Studies | Supply Chain Management | MAO
 | 2012-11-05 00:00:00 |  | C | Ms. | Foronda | Micheline | Mitch | Nutrition Specialist | N Infant Nutrition | MAO
 | 2012-09-16 00:00:00 |  | C | Ms. | [NAME] | [NAME] | [NAME] | Administration Specialist | Technical | MAO
 | 2012-11-05 00:00:00 |  | I | Mr. | Guerrero | [NAME] | Jed | Nutrition Specialist | N Infant Nutrition | MAO
 | 2012-11-05 00:00:00 |  | I | Ms. | [NAME] | [NAME] |  | Administration Specialist | Technical | MAO
 | 2011-12-12 00:00:00 |  | D | Ms. | Jacinto | Krista Mae |  | Nutrition Specialist | N Infant Nutrition | MAO
 | 2012-04-02 00:00:00 |  | D | Mr. | Javier | [NAME] | [NAME] | Consumer Marketing Executive - Beverages | Beverages | MAO
 | 2012-11-16 00:00:00 |  | C | Mr. | Juan | Ferdinand | [NAME] | Legal Executive | Legal | MAO
 | 2012-07-02 00:00:00 |  | I | Mr. | Lanzaderas | Marlery | Marlery | Nutrition Specialist | N Infant Nutrition | MAO
 | 2011-10-10 00:00:00 |  | C | Mr. | Magat | [NAME] | Ian | Area Nutrition Manager | N Infant Nutrition | MAO
 | 2012-11-05 00:00:00 |  | C | Mr. | [NAME] | [NAME] | [NAME] | Learning and Development Manager | Human Resources | CDO
 | 2012-10-01 00:00:00 |  | I | Ms. | Manible | Fate May | Fate | Nutrition Specialist | N Infant Nutrition | MAO
 | 2012-11-16 00:00:00 |  | I | Mr. | Marmolejo | [NAME] | Art | Inbound Material Management Planner | Technical | MAO
 | 2012-10-01 00:00:00 |  | C | Ms. | Mendoza | Lyn Jasmin | [NAME] | OPD-Admn. Specialist | Technical | MAO
 | 2012-09-17 00:00:00 |  | C | Ms. | Moises | Venus | Venus | Nutrition Specialist | N Infant Nutrition | MAO
 | 2012-11-05 00:00:00 |  | C | Ms. | Obrador | Roniña | Niña | Inbound Material Management Planner | Technical | MAO
 | 2011-10-17 00:00:00 |  | C | Mr. | Panaligan | Ronel | Une | Process Line Operator | Technical | TF
 | 2012-11-16 00:00:00 |  | D | Mr. | [NAME] | [NAME] | Gerard | Channel Business Specialist | Grocery Sales | NL SO
 | 2012-09-17 00:00:00 |  | C | Ms. | Piñon | [NAME] | [NAME] | Packaging Development Executive | Packaging Services | MAO
 | 2011-10-10 00:00:00 |  | C | Ms. | [NAME] | Fate |  | Nutrition Specialist | N Infant Nutrition | MAO
 | 2011-10-24 00:00:00 |  | C | Mr. | Raymundo | [NAME] |  | Nutrition Specialist | N Infant Nutrition | MAO
 | 2012-07-09 00:00:00 |  | I | Mr. | Rodriguez | Alixandre | [NAME] | Operation Performance Engineer | Technical | CDO
 | 2012-04-16 00:00:00 |  | D | Ms. | See | [NAME] | Jovee | Consumer Marketing Executive - Food | Food BU | MAO
 | 2011-09-12 00:00:00 |  | C | Ms. | Serquina | [NAME] |  | Nutrition Specialist | N Infant Nutrition | MAO
 | 2012-11-16 00:00:00 |  | D | Mr. | Soverano | [NAME] | JayR | Inbound Material Management Planner | Technical | MAO
 | 2012-07-02 00:00:00 |  | I | Mr. | Suayan | [NAME] | [NAME] | HealthCare Key Accounts Specialist | N Health Science | MAO
 | 2012-11-05 00:00:00 |  | D | Ms. | Sumpaico | Lissa | Lissa | HR Executive - Recruitment | Human Resources | MAO
 | 2012-08-16 00:00:00 |  | C | Mr. | Testa | [NAME] | [NAME] | Logistics Specialist-Budgets and Reporting | Supply Chain Management | MAO
 | 2012-06-07 00:00:00 |  | C | Ms. | Tiu Serra | [NAME] | Grace | Operations Performance Engineer | Technical | CF
 | 2012-09-17 00:00:00 |  | C | Ms. | Torregosa | Jemima | [NAME] | Nutrition Specialist | N Infant Nutrition | MAO
 | 2012-10-16 00:00:00 |  | I | Mr. | Tumao | Theodore | [NAME] | Finance & Operations Excellence Specialist | DMG | MAO
 | 2012-06-11 00:00:00 |  | I | Ms. | Yabut | Vanessa Mae | [NAME] | Nutrition Specialist | N Infant Nutrition | MAO