Spreadsheet: 161899d1339670227-combine-multiple-workbooks-based-on-a-common-column-rdbmerge-compiled
Sheet: Combine Sheet

F:\PERR\Example (Excel Forum)\Example-Andy.xls | F:\PERR\Example (Excel Forum)\Example-Andy.xls | F:\PERR\Example (Excel Forum)\Example-Andy.xls | F:\PERR\Example (Excel Forum)\Example-Andy.xls | F:\PERR\Example (Excel Forum)\Example-Andy.xls | F:\PERR\Example (Excel Forum)\Example-Andy.xls | F:\PERR\Example (Excel Forum)\Example-Bob.xls | F:\PERR\Example (Excel Forum)\Example-Bob.xls | F:\PERR\Example (Excel Forum)\Example-Bob.xls | F:\PERR\Example (Excel Forum)\Example-Bob.xls | F:\PERR\Example (Excel Forum)\Example-Bob.xls | F:\PERR\Example (Excel Forum)\Example-Bob.xls | F:\PERR\Example (Excel Forum)\Example-Dave.xls | F:\PERR\Example (Excel Forum)\Example-Dave.xls | F:\PERR\Example (Excel Forum)\Example-Dave.xls | F:\PERR\Example (Excel Forum)\Example-Dave.xls | F:\PERR\Example (Excel Forum)\Example-Dave.xls | F:\PERR\Example (Excel Forum)\Example-Dave.xls
RecID | Group Name | Owner Name | [NAME] | EMP ID | AD ID | RecID | Group Name | Owner Name | [NAME] | EMP ID | AD ID | RecID | Group Name | Owner Name | [NAME] | EMP ID | AD ID
5 | ExampleGroup5 | [NAME] | [EMAIL] | 654321 | AndreA | 5 | ExampleGroup5 | [NAME] | [EMAIL] | 123456 | BOBINB
14 | ExampleGroup14 | [NAME] | [EMAIL] | 654321 | AndreA | 14 | ExampleGroup14 | [NAME] | [EMAIL] | 123456 | BOBINB
35 | ExampleGroup35 | [NAME] | [EMAIL] | 654321 | AndreA | 35 | ExampleGroup35 | [NAME] | [EMAIL] | 123456 | BOBINB
47 | ExampleGroup47 | [NAME] | [EMAIL] | 654321 | AndreA | 47 | ExampleGroup47 | [NAME] | [EMAIL] | 123456 | BOBINB
2 | ExampleGroup2 | [NAME] | [EMAIL] | 123456 | BOBINB | 2 | ExampleGroup2 | [NAME] | [EMAIL] | 987456 | DavidD
3 | ExampleGroup3 | [NAME] | [EMAIL] | 123456 | BOBINB | 3 | ExampleGroup3 | [NAME] | [EMAIL] | 987456 | DavidD
4 | ExampleGroup4 | [NAME] | [EMAIL] | 654321 | AndreA | 4 | ExampleGroup4 | [NAME] | [EMAIL] | 987456 | DavidD
8 | ExampleGroup8 | [NAME] | [EMAIL] | 123456 | BOBINB | 8 | ExampleGroup8 | [NAME] | [EMAIL] | 987456 | DavidD
10 | ExampleGroup10 | [NAME] | [EMAIL] | 123456 | BOBINB | 10 | ExampleGroup10 | [NAME] | [EMAIL] | 987456 | DavidD
11 | ExampleGroup11 | [NAME] | [EMAIL] | 123456 | BOBINB | 11 | ExampleGroup11 | [NAME] | [EMAIL] | 987456 | DavidD
12 | ExampleGroup12 | [NAME] | [EMAIL] | 123456 | BOBINB | 12 | ExampleGroup12 | [NAME] | [EMAIL] | 987456 | DavidD
15 | ExampleGroup15 | [NAME] | [EMAIL] | 123456 | BOBINB | 15 | ExampleGroup15 | [NAME] | [EMAIL] | 987456 | DavidD
19 | ExampleGroup19 | [NAME] | [EMAIL] | 654321 | AndreA | 19 | ExampleGroup19 | [NAME] | [EMAIL] | 987456 | DavidD
22 | ExampleGroup22 | [NAME] | [EMAIL] | 654321 | AndreA | 22 | ExampleGroup22 | [NAME] | [EMAIL] | 987456 | DavidD
23 | ExampleGroup23 | [NAME] | [EMAIL] | 123456 | BOBINB | 23 | ExampleGroup23 | [NAME] | [EMAIL] | 987456 | DavidD
26 | ExampleGroup26 | [NAME] | [EMAIL] | 123456 | BOBINB | 26 | ExampleGroup26 | [NAME] | [EMAIL] | 987456 | DavidD
28 | ExampleGroup28 | [NAME] | [EMAIL] | 654321 | AndreA | 28 | ExampleGroup28 | [NAME] | [EMAIL] | 987456 | DavidD
32 | ExampleGroup32 | [NAME] | [EMAIL] | 123456 | BOBINB | 32 | ExampleGroup32 | [NAME] | [EMAIL] | 987456 | DavidD
33 | ExampleGroup33 | [NAME] | [EMAIL] | 654321 | AndreA | 33 | ExampleGroup33 | [NAME] | [EMAIL] | 987456 | DavidD
37 | ExampleGroup37 | [NAME] | [EMAIL] | 654321 | AndreA | 37 | ExampleGroup37 | [NAME] | [EMAIL] | 987456 | DavidD
38 | ExampleGroup38 | [NAME] | [EMAIL] | 123456 | BOBINB | 38 | ExampleGroup38 | [NAME] | [EMAIL] | 987456 | DavidD
42 | ExampleGroup42 | [NAME] | [EMAIL] | 123456 | BOBINB | 42 | ExampleGroup42 | [NAME] | [EMAIL] | 987456 | DavidD
43 | ExampleGroup43 | [NAME] | [EMAIL] | 123456 | BOBINB | 43 | ExampleGroup43 | [NAME] | [EMAIL] | 987456 | DavidD
48 | ExampleGroup48 | [NAME] | [EMAIL] | 123456 | BOBINB | 48 | ExampleGroup48 | [NAME] | [EMAIL] | 987456 | DavidD
49 | ExampleGroup49 | [NAME] | [EMAIL] | 123456 | BOBINB | 49 | ExampleGroup49 | [NAME] | [EMAIL] | 987456 | DavidD
1 | ExampleGroup1 | [NAME] | [EMAIL] | 123456 | BOBINB
6 | ExampleGroup6 | [NAME] | [EMAIL] | 654321 | AndreA
7 | ExampleGroup7 | [NAME] | [EMAIL] | 987456 | DavidD
9 | ExampleGroup9 | [NAME] | [EMAIL] | 654321 | AndreA
13 | ExampleGroup13 | [NAME] | [EMAIL] | 654321 | AndreA
16 | ExampleGroup16 | [NAME] | [EMAIL] | 987456 | DavidD
17 | ExampleGroup17 | [NAME] | [EMAIL] | 123456 | BOBINB
18 | ExampleGroup18 | [NAME] | [EMAIL] | 123456 | BOBINB
20 | ExampleGroup20 | [NAME] | [EMAIL] | 123456 | BOBINB
21 | ExampleGroup21
24 | ExampleGroup24 | [NAME] | [EMAIL] | 654321 | AndreA
25 | ExampleGroup25 | [NAME] | [EMAIL] | 123456 | BOBINB
27 | ExampleGroup27
29 | ExampleGroup29 | [NAME] | [EMAIL] | 654321 | AndreA
30 | ExampleGroup30 | [NAME] | [EMAIL] | 123456 | BOBINB
31 | ExampleGroup31 | [NAME] | [EMAIL] | 123456 | BOBINB
34 | ExampleGroup34 | [NAME] | [EMAIL] | 123456 | BOBINB
36 | ExampleGroup36 | [NAME] | [EMAIL] | 654321 | AndreA
39 | ExampleGroup39 | [NAME] | [EMAIL] | 123456 | BOBINB
40 | ExampleGroup40 | [NAME] | [EMAIL] | 123456 | BOBINB
41 | ExampleGroup41
44 | ExampleGroup44 | [NAME] | [EMAIL] | 654321 | AndreA
45 | ExampleGroup45 | [NAME] | [EMAIL] | 654321 | AndreA
46 | ExampleGroup46 | [NAME] | [EMAIL] | 654321 | AndreA