Spreadsheet: 329173d1404221894-how-do-i-autopopulate-data-from-1-database-to-another-in-excel-2003-database-master
Sheet: AUDITING MATRIX

DATABASE 1 - MAJOR
 | Total Auditors                              (Total increases as you [NAME] to Individuals DATABASE 2 - minor log) |  |  | COURSES |  | Total A |  |  | Total ATL |  |  | Notes / Comments
 | 0 |  |  | Booked | 4 | 10 |  |  | 4
 |  |  |  | Completed | 24
AREA | Name                                             (Hyperlink to Individual DATABASE 2 - MINOR Log) | Contact No | [NAME] | COMPLETION DATE | Booked /                Completed | Auditor                ([NAME]) |  | TOTAL                                  (No of Auditing days) | Audit Team Leader                    ([NAME]) |  | AUDITING (Total days)
Area A | Person A |  |  | 2012-01-27 00:00:00 | C | 2017-03-03 00:00:00 | 1 | 2 | 2017-03-03 00:00:00 | 1 | 6
Area A | Person B |  |  | 2011-06-24 00:00:00 | C | 2017-03-03 00:00:00 | 1 | 7 | 2017-03-03 00:00:00 | 1 | 0
Area A | Person C |  |  | 2011-03-11 00:00:00 | C | 2017-03-03 00:00:00 | 1 |  | 2017-03-03 00:00:00 | 1
Area A |  |  |  | 2011-08-12 00:00:00 | C | 2017-03-03 00:00:00 | 1 |  | 2017-03-03 00:00:00 | 1
Area B | Person D |  |  | 2011-07-29 00:00:00 | C | 2017-02-17 00:00:00 | 1 |  |  | 0
Area B | Person E |  |  | 2013-05-18 00:00:00 | C |  | 0
Area B | Person F |  |  | 2011-09-16 00:00:00 | C |  | 0
Area B | Person G |  |  | 2009-08-07 00:00:00 | B |  | 0 |  |  | 0
Area B
Area C | Person H |  |  | 2008-12-05 00:00:00 | C |  | 0 |  |  | 0
Area C | Person I |  |  |  | B
Area C | Person J |  |  | 2007-05-25 00:00:00 | C
Area C |  |  |  |  |  |  | 0 |  |  | 0
Area D | Person K |  |  | 2014-05-16 00:00:00 | C
Area D | Person L |  |  | 2012-09-21 00:00:00 | C |  | 0 |  |  | 0
Area D
Area E | Person M |  |  | 2013-08-09 00:00:00 | C | 2017-04-24 00:00:00 | 1 |  |  | 0
Area E
Area F | Person N |  |  | 2012-04-20 00:00:00 | C | 2017-03-06 00:00:00 | 1 |  |  | 0
Area F | Person O |  |  | 2014-04-04 00:00:00 | C |  | 0 |  |  | 0
Area F | Person P |  |  | 2009-04-24 00:00:00 | C |  | 0
Area F | Person Q |  |  | 2013-01-18 00:00:00 | C |  | 0
Area F | Person R |  |  | 2011-01-21 00:00:00 | C |  | 0 |  |  | 0
Area F |  |  |  |  |  |  | 0 |  |  | 0
Area G | Person S |  |  | 2010-01-22 00:00:00 | C |  | 0 |  |  | 0
Area G |  |  |  |  |  |  | 0 |  |  | 0
Area H | Person T |  |  | 2011-01-14 00:00:00 | C | 2017-03-03 00:00:00 | 1 |  |  | 0
Area H | Person U |  |  | 2012-09-07 00:00:00 | C | 2017-03-03 00:00:00 | 1 |  |  | 0
Area H | Person V |  |  | 2011-01-14 00:00:00 | C |  | 0
Area H
Area I | Person W |  |  | 2013-07-31 00:00:00 | 2013-07-31 00:00:00 |  | 0 |  |  | 0
Area I
Area J | Person X |  |  | 2013-12-13 00:00:00 | C | 2017-04-22 00:00:00 | 1 |  |  | 0
Area J | Person Y |  |  | 2006-11-06 00:00:00 | C | 2010-12-12 00:00:00 | 0
Area J |  |  |  |  |  |  | 0 |  |  | 0
Area K | Person Z |  |  |  | B |  | 0 |  |  | 0
Area K |  |  |  |  |  |  | 0 |  |  | 0
Area K |  |  |  |  |  |  | 0 |  |  | 0
Area L | Person A1 |  |  | 2008-06-27 00:00:00 | C |  | 0 |  |  | 0
Area L |  |  |  |  |  |  | 0 |  |  | 0
Area L |  |  |  |  |  |  | 0 |  |  | 0
Area M | Person B1 |  |  |  | B |  | 0 |  |  | 0
Area M |  |  |  |  |  |  | 0 |  |  | 0
Area M |  |  |  |  |  |  | 0 |  |  | 0
Area M |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0