Spreadsheet: 130708d1322528803-excel-2007-auto-populate-data-seems-complicated-sl-notification_excel-forum
Sheet: Data

Team | Current Assignment | Resource Name | Team Leader (local) | TO | CC | BCC
Team 1 | Assignment 1 | Resource 1 | Leader 1
Team 1 | Assignment 1 | Resource 2 | Leader 1
Team 1 | Assignment 1 | Resource 3 | Leader 1
Team 1 | Assignment 2 | Resource 4 | Leader 2
Team 1 | Assignment 2 | Resource 5 | Leader 2
Team 1 | Assignment 2 | Resource 6 | Leader 1
Team 2 | Assignment 2 | Resource 7 | Leader 1
Team 2 | Assignment 2 | Resource 8 | Leader 1
Team 2 | Assignment 2 | Resource 9 | Leader 1
Team 2 | Assignment 2 | Resource 10 | Leader 2
Team 2 | Assignment 2 | Resource 11 | Leader 4
Team 2 | Assignment 2 | Resource 12 | Leader 2
Team 2 | Assignment 2 | Resource 13 | Leader 2
Team 2 | Assignment 2 | Resource 14 | Leader 2
Team 2 | Assignment 2 | Resource 15 | Leader 2
Team 2 | Assignment 2 | Resource 16 | Leader 4
Team 2 | Assignment 2 | Resource 17 | Leader 1
Team 2 | Assignment 2 | Resource 18 | Leader 1
Team 2 | Assignment 2 | Resource 19 | Leader 2
Team 2 | Assignment 2 | Resource 20 | Leader 2
Team 2 | Assignment 2 | Resource 21 | Leader 2
Team 2 | Assignment 2 | Resource 22 | Leader 1
Team 2 | Assignment 2 | Resource 23 | Leader 1
Team 3 | Assignment 2 | Resource 24 | Leader 1
Team 3 | Assignment 2 | Resource 25 | Leader 1
Team 3 | Assignment 2 | Resource 26 | Leader 1
Team 3 | Assignment 2 | Resource 27 | Leader 2
Team 3 | Assignment 3 | Resource 28 | Leader 2
Team 3 | Assignment 3 | Resource 29 | Leader 1
Team 3 | Assignment 3 | Resource 30 | Leader 3
Team 3 | Assignment 3 | Resource 31 | Leader 2
Team 3 | Assignment 3 | Resource 32 | Leader 2
Team 3 | Assignment 3 | Resource 33 | Leader 3
Team 3 | Assignment 3 | Resource 34 | Leader 3
Team 3 | Assignment 3 | Resource 35 | Leader 3
Team 3 | Assignment 3 | Resource 36 | Leader 2
Team 3 | Assignment 3 | Resource 37 | Leader 2
Team 3 | Assignment 3 | Resource 38 | Leader 3
Team 3 | Assignment 3 | Resource 39 | Leader 3
Team 3 | Assignment 3 | Resource 40 | Leader 3
Team 3 | Assignment 3 | Resource 41 | Leader 4
Team 3 | Assignment 3 | Resource 42 | Leader 4
Team 3 | Assignment 3 | Resource 43 | Leader 4
Team 3 | Assignment 3 | Resource 44 | Leader 4
Team 3 | Assignment 3 | Resource 45 | Leader 3
Team 3 | Assignment 3 | Resource 46 | Leader 3
Team 3 | Assignment 3 | Resource 47 | Leader 4
Team 3 | Assignment 4 | Resource 48 | Leader 1
Team 3 | Assignment 4 | Resource 49 | Leader 1
Team 3 | Assignment 4 | Resource 50 | Leader 2
Team 3 | Assignment 4 | Resource 51 | Leader 2
Team 3 | Assignment 4 | Resource 52 | Leader 1
Team 3 | Assignment 4 | Resource 53 | Leader 1
Team 3 | Assignment 4 | Resource 54 | Leader 3
Team 3 | Assignment 4 | Resource 55 | Leader 3
Team 3 | Assignment 4 | Resource 56 | Leader 2
Team 3 | Assignment 4 | Resource 57 | Leader 3
Team 3 | Assignment 4 | Resource 58 | Leader 2
Team 3 | Assignment 4 | Resource 59 | Leader 3
Team 3 | Assignment 4 | Resource 60 | Leader 3
Team 3 | Assignment 4 | Resource 61 | Leader 1
Team 4 | Assignment 4 | Resource 62 | Leader 2
Team 4 | Assignment 4 | Resource 63 | Leader 2
Team 4 | Assignment 4 | Resource 64 | Leader 1
Team 4 | Assignment 4 | Resource 65 | Leader 2
Team 4 | Assignment 4 | Resource 66 | Leader 3
Team 4 | Assignment 4 | Resource 67 | Leader 1
Team 4 | Assignment 4 | Resource 68 | Leader 1
Team 4 | Assignment 4 | Resource 69 | Leader 2