Spreadsheet: 103258d1301012839-reference-data-from-one-sheet-to-another-audit-1-
Sheet: Sheet2

Port |  |  | Mac Address | VLAN
Gi1/0/5 |  |  | 00e0.8179.d123 | 1105
Gi1/0/7 |  |  | 001e.c9b0.3425 | 1104
Gi1/0/8 |  |  | 0013.7264.9b1c | 20
Gi1/0/13 |  |  | a4ba.db20.9778 | 2023
Gi1/0/16 |  |  | 0014.4f60.a67d | 3
Gi1/0/17 |  |  | 0015.1768.5323 | 1109
Gi1/0/20 |  |  | 78e7.d1e5.1884 | 1105
Gi1/0/22 |  |  | 0019.b9e3.2fbd | 1104
Gi1/0/29 |  |  | 000f.1f6e.25b3 | 1104
Gi1/0/30 |  |  | 00a0.690a.f3d0 | 500
Gi1/0/31 |  |  | d485.6463.a3d8 | 1105
Gi1/0/34 |  |  | 0013.7264.addb | 20
Gi1/0/38 |  |  | 0014.221e.d692 | 21
Gi1/0/39 |  |  | 000e.7f7d.3de6 | 205
Gi1/0/43 |  |  | 0014.221e.d691 | 21
Gi1/0/44 |  |  | 0011.257d.0498 | 251
[NAME] |  |  | 0014.5ed1.2806 | 1200
Gi1/0/48 |  |  | 0015.1767.74a5 | 1109
Gi2/0/1 |  |  | 0013.c468.703d | 2000
Gi2/0/4 |  |  | 0019.b9df.d7cb | 1109
Gi2/0/5 |  |  | 0013.724c.17d2 | 15
Gi2/0/7 |  |  | 0013.7264.a8e5 | 21
Gi2/0/8 |  |  | 0013.7264.a8e4 | 21
Gi2/0/9 |  |  | 001e.c9b5.0b1e | 1109
Gi2/0/10 |  |  | 0026.55dc.e2e7 | 1114
Gi2/0/11 |  |  | 000b.cdfd.98ee | 1104
Gi2/0/12 |  |  | 000b.cdfd.8772 | 20
Gi2/0/13 |  |  | 000b.cdfd.e29d | 20
Gi2/0/14 |  |  | 000b.cdfe.2105 | 20
Gi2/0/16 |  |  | 0015.1775.af9b | 1109
Gi2/0/17 |  |  | 0015.1729.1889 | 1109
Gi2/0/18 |  |  | 000b.cdce.3b6f | 20
[NAME] |  |  | 00e0.815b.b578 | 21
Gi2/0/21 |  |  | 0016.9dc8.92b0 | 206
Gi2/0/22 |  |  | 0016.9dc8.859c | 206
Gi2/0/26 |  |  | 0201.0a01.055a | 20
Gi2/0/28 |  |  | 0013.7254.9039 | 1104
Gi2/0/29 |  |  | 0013.7263.25a4 | 20
Gi2/0/30 |  |  | 0013.7254.90da | 1104
Gi2/0/32 |  |  | 0013.7254.9086 | 1104
Gi2/0/33 |  |  | 0013.7263.25bb | 1104
Gi2/0/34 |  |  | 0013.7254.907b | 1104
Gi2/0/35 |  |  | 0013.7263.2564 | 1104
Gi2/0/36 |  |  | 001a.6497.bb54 | 1112
Gi2/0/38 |  |  | 000f.1f6d.da07 | 20
Gi2/0/40 |  |  | d485.6463.d504 | 1105
Gi2/0/41 |  |  | d485.6466.9154 | 1109
Gi2/0/42 |  |  | d485.6466.935c | 1109
Gi2/0/44 |  |  | 0018.8b46.4be8 | 1105
Gi2/0/45 |  |  | 0018.8b46.4d2d | 1105
Gi2/0/47 |  |  | 0013.7264.8720 | 5
Gi2/0/48 |  |  | 0013.7264.871f | 5
Gi3/0/1 |  |  | 0015.c5e6.6990 | 1105
Gi3/0/2 |  |  | 0030.4890.a98c | 1105
Gi3/0/3 |  |  | 0013.7254.907a | 1104
Gi3/0/9 |  |  | 00e0.81b1.6aa5 | 1106
[NAME] |  |  | 0015.177b.2e9e | 3
Gi3/0/14 |  |  | 0019.b9e3.c161 | 1104
Gi3/0/17 |  |  | 0013.72f9.17d9 | 1104
Gi3/0/18 |  |  | 0013.72f9.17d7 | 1104
Gi3/0/21 |  |  | 0013.7254.bc77 | 1104
Gi3/0/22 |  |  | 0013.7254.bc76 | 1104
Gi3/0/24 |  |  | 0014.5ed1.2804 | 251
Gi3/0/25 |  |  | 001d.0966.2107 | 1104
Gi3/0/26 |  |  | 001a.a03c.4484 | 1105
Gi3/0/28 |  |  | 001d.0966.2109 | 1104
Gi3/0/30 |  |  | 001e.c9da.e718 | 104
Gi3/0/32 |  |  | 0011.43e8.bbb7 | 20
Gi3/0/34 |  |  | 000f.1f6e.25b2 | 1104
Gi3/0/35 |  |  | 001d.091e.8ba4 | 1105
Gi3/0/37 |  |  | 0015.1748.a38d | 1109
Gi3/0/38 |  |  | 0015.1748.a609 | 1109
Gi3/0/40 |  |  | 0015.1748.a6f7 | 1109
Gi3/0/42 |  |  | 0015.1748.a6f5 | 1109
Gi3/0/44 |  |  | 0011.25c0.8082 | 21
Gi3/0/45 |  |  | 0014.5ec6.9182 | 1200
Gi3/0/46 |  |  | 0014.5ec6.9183 | 21
Gi4/0/1 |  |  | 000d.600f.1248 | 1105
Gi4/0/2 |  |  | 0014.220d.d558 | 8
Gi4/0/3 |  |  | 0014.220d.d557 | 8
Gi4/0/5 |  |  | 001b.211e.f999 | 401
Gi4/0/6 |  |  | 001b.211e.f5b9 | 401
Gi4/0/10 |  |  | 0015.1751.4a37 | 1105
Gi4/0/11 |  |  | 00d0.fa83.1312 | 139
Gi4/0/12 |  |  | 0006.29c3.18f0 | 110
Gi4/0/13 |  |  | 78e7.d1b1.120d | 104
Gi4/0/14 |  |  | 78e7.d1b1.1201 | 104
Gi4/0/16 |  |  | 000d.601b.48d6 | 21
Gi4/0/19 |  |  | 0002.553a.1d8e | 206
Gi4/0/21 |  |  | 0002.554f.67d9 | 206
Gi4/0/22 |  |  | 00e0.81b1.6c64 | 1106
Gi4/0/27 |  |  | 0022.19b2.90c5 | 1105
Gi4/0/28 |  |  | 0022.19b2.8a9d | 1105
Gi4/0/30 |  |  | 0021.2806.f211 | 3
Gi4/0/31 |  |  | 0021.2806.f210 | 1100
Gi4/0/32 |  |  | 0021.2806.f20f | 1100
Gi4/0/33 |  |  | 0021.2806.f20e | 1100
Gi4/0/34 |  |  | 00d0.fa83.1e2c | 52
Gi4/0/35 |  |  | d8d3.85aa.6646 | 1105
Gi4/0/36 |  |  | d8d3.85aa.6648 | 1105
Gi4/0/37 |  |  | d8d3.85aa.664a | 3
Gi4/0/38 |  |  | d8d3.85aa.42ec | 1105
Gi4/0/39 |  |  | d8d3.85aa.42ee | 1105
Gi4/0/40 |  |  | d8d3.85aa.42f0 | 3
Gi4/0/41 |  |  | d8d3.85aa.2f96 | 104
Gi4/0/42 |  |  | d8d3.85aa.2f98 | 104
Gi4/0/44 |  |  | d8d3.85aa.a39a | 1105
Gi4/0/45 |  |  | d8d3.85aa.a39c | 1105
Gi4/0/46 |  |  | 0014.5e81.82f3 | 16
Gi4/0/48 |  |  | 0014.4fd2.9d1c | 16
Gi5/0/1 |  |  | 0021.2806.f551 | 3
Gi5/0/2 |  |  | 0021.2806.f550 | 1100
Gi5/0/3 |  |  | 0021.2806.f54f | 1100
Gi5/0/4 |  |  | 0021.2806.f54e | 1100
Gi5/0/5 |  |  | d8d3.85aa.ee68 | 1105
Gi5/0/6 |  |  | d8d3.85aa.ee6a | 1105
Gi5/0/8 |  |  | 0014.5ef0.4db4 | 420
Gi5/0/9 |  |  | 0025.b3e2.1572 | 104
Gi5/0/10 |  |  | 0024.81e8.a03a | 1105
Gi5/0/12 |  |  | 0025.b3e2.1576 | 3
Gi5/0/13 |  |  | 0023.5eec.cc6c | 3
Gi5/0/14 |  |  | 0002.554f.b822 | 104
Gi5/0/17 |  |  | 0017.a477.0810 | 104
Gi5/0/17 |  |  | 0017.a477.0812 | 104
Gi5/0/17 |  |  | 0017.a477.0814 | 104
Gi5/0/17 |  |  | 0017.a477.0816 | 104
Gi5/0/17 |  |  | 0017.a477.08a0 | 104
Gi5/0/17 |  |  | 18a9.05ea.405d | 104
Gi5/0/18 |  |  | 001e.c9b5.0b1c | 1109
[NAME] |  |  | 0019.b9df.d7c9 | 1109
Gi5/0/22 |  |  | 0023.7ddf.58f8 | 1105
Gi5/0/24 |  |  | 0014.4f6b.38b1 | 21
Gi5/0/25 |  |  | 18a9.0562.2948 | 1105
Gi5/0/26 |  |  | 18a9.0562.294a | 1105
Gi5/0/27 |  |  | 0023.7ddf.58f6 | 3
Gi5/0/31 |  |  | 001b.2133.94b8 | 3
Gi5/0/32 |  |  | [NAME] | 1105
Gi5/0/33 |  |  | d8d3.85a9.c5fc | 1105
Gi5/0/39 |  |  | 0023.7ddf.5840 | 104
Gi5/0/40 |  |  | d8d3.85aa.6678 | 1105
Gi5/0/41 |  |  | d8d3.85aa.667a | 1105
Gi5/0/43 |  |  | d8d3.85aa.9e0e | 1105
Gi5/0/44 |  |  | d8d3.85aa.9e10 | 1105
[NAME] |  |  | d8d3.85a7.193e | 1105
Gi5/0/47 |  |  | d8d3.85a7.1940 | 1105