Appendix Thread 2. ( Codes for other Threads, HTML Tables, etc.)

Bottom part of worksheet shown in last Post
here we see new data added ( rows 47 to 51 ( S No 46 - S no 50 )

Using Excel 2007 32 bit

16
ABC16
$ 333.45

99

$ 33,011.55

15. Mrz 18
MT1 MT2 MT3 MT4
16. Mrz 18

16. Mrz 18
Margaret

17
ABC17
$ 11.99

1

$ 11.99

15. Mrz 18
RT1 RT2 RT3 RT4
16. Mrz 18

16. Mrz 18
Raghu

18
ABC18
$ 741.99

101

$ 74,940.99

15. Mrz 18
JT1 JT2 JT3 JT4
16. Mrz 18

16. Mrz 18
John

19
ABC19
$ 55.00

22

$ 1,210.00

15. Mrz 18
GT1 GT2 GT3 GT4
16. Mrz 18

16. Mrz 18
Greg

20
ABC20
$ 13.66

7

$ 95.62

15. Mrz 18
MT1 MT2 MT3 MT4
16. Mrz 18

16. Mrz 18
Margaret

21
ABC21
$ 12.99

5

$ 64.95

15. Mrz 18
Raghu

22
ABC22
$ 8.51

12

$ 102.12

15. Mrz 18
JT1 JT2 JT3 JT4
16. Mrz 18

16. Mrz 18
John

23
ABC23
$ 7.22

62

$ 447.64

15. Mrz 18
Greg

24
ABC24
$ 3.99

35

$ 139.65

15. Mrz 18
MT1 MT2 MT3 MT4
16. Mrz 18

16. Mrz 18
Margaret

25
ABC25
$ 333.45

99

$ 33,011.55

15. Mrz 18
Raghu

26
ABC26
$ 11.99

1

$ 11.99

15. Mrz 18
John

27
ABC27
$ 741.99

101

$ 74,940.99

15. Mrz 18
Greg

28
ABC28
$ 55.00

22

$ 1,210.00

15. Mrz 18
MT1 MT2 MT3 MT4
16. Mrz 18

16. Mrz 18
Margaret

29
ABC29
$ 13.66

7

$ 95.62

15. Mrz 18
Raghu

30
ABC30
$ 12.99

5

$ 64.95

15. Mrz 18
John

31
ABC31
$ 8.51

12

$ 102.12

15. Mrz 18
Greg

32
ABC32
$ 7.22

62

$ 447.64

15. Mrz 18
Margaret

33
ABC33
$ 3.99

35

$ 139.65

15. Mrz 18
Raghu

34
ABC34
$ 333.45

99

$ 33,011.55

15. Mrz 18
John

35
ABC35
$ 11.99

1

$ 11.99

15. Mrz 18
Greg

36
ABC36
$ 741.99

101

$ 74,940.99

15. Mrz 18
Margaret

37
ABC37
$ 55.00

22

$ 1,210.00

15. Mrz 18
Raghu

38
ABC38
$ 13.66

7

$ 95.62

15. Mrz 18
John

39
ABC39
$ 12.99

5

$ 64.95

15. Mrz 18
Greg

40
ABC40
$ 8.51

12

$ 102.12

15. Mrz 18
Margaret

41
ABC41
$ 7.22

62

$ 447.64

15. Mrz 18
Raghu

42
ABC42
$ 3.99

35

$ 139.65

15. Mrz 18
John

43
ABC43
$ 333.45

99

$ 33,011.55

15. Mrz 18
Greg

44
ABC44
$ 11.99

1

$ 11.99

15. Mrz 18
Margaret

45
ABC45
$ 741.99

101

$ 74,940.99

15. Mrz 18
Raghu

46
ABC46
$ 8.51

12

$ 102.12

16. Mrz 18
John

47
ABC47
$ 7.22

62

$ 447.64

16. Mrz 18
Greg

48
ABC48
$ 3.99

35

$ 139.65

16. Mrz 18
Margaret

49
ABC49
$ 333.45

99

$ 33,011.55

16. Mrz 18
Raghu

50
ABC50
$ 11.99

1

$ 11.99

16. Mrz 18
Raghu

Worksheet: OriginalData

Typical Updated Data File, "Raghu.xlsx" after first consolidation

Typical Updated Data File, "Raghu.xlsx" after first consolidation,
with the column L updated appropriately with the consolidation date

Using Excel 2007 32 bit

_Row\^Col
A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

1

S No

Item

Price

Qty

Total

Distributed

Task1

Task2

Task3

Task4

Completed

Consolidated

Comments

Team Member

2

1
ABC01
$ 55.00

22

$ 1,210.00
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
02.Apr.2018 Raghu

3

5
ABC05
$ 7.22

62

$ 447.64
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
02.Apr.2018 Raghu

4

9
ABC09
$ 741.99

101

$ 74,940.99
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
02.Apr.2018 Raghu

5

13
ABC13
$ 8.51

12

$ 102.12
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
02.Apr.2018 Raghu

6

17
ABC17
$ 11.99

1

$ 11.99
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
02.Apr.2018 Raghu

7

21
ABC21
$ 12.99

5

$ 64.95
02.Apr.2018 Raghu

8

25
ABC25
$ 333.45

99

$ 33,011.55
02.Apr.2018 Raghu

9

29
ABC29
$ 13.66

7

$ 95.62
02.Apr.2018 Raghu

10

33
ABC33
$ 3.99

35

$ 139.65
02.Apr.2018 Raghu

11

37
ABC37
$ 55.00

22

$ 1,210.00
02.Apr.2018 Raghu

12

41
ABC41
$ 7.22

62

$ 447.64
02.Apr.2018 Raghu

13

45
ABC45
$ 741.99

101

$ 74,940.99
02.Apr.2018 Raghu

14

Worksheet: Tabelle1

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member
2	1	ABC01	$ 55.00	22	$ 1,210.00	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018		Raghu
3	5	ABC05	$ 7.22	62	$ 447.64	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018		Raghu
4	9	ABC09	$ 741.99	101	$ 74,940.99	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018		Raghu
5	13	ABC13	$ 8.51	12	$ 102.12	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018		Raghu
6	17	ABC17	$ 11.99	1	$ 11.99	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018		Raghu
7	21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018								Raghu
8	25	ABC25	$ 333.45	99	$ 33,011.55	02.Apr.2018								Raghu
9	29	ABC29	$ 13.66	7	$ 95.62	02.Apr.2018								Raghu
10	33	ABC33	$ 3.99	35	$ 139.65	02.Apr.2018								Raghu
11	37	ABC37	$ 55.00	22	$ 1,210.00	02.Apr.2018								Raghu
12	41	ABC41	$ 7.22	62	$ 447.64	02.Apr.2018								Raghu
13	45	ABC45	$ 741.99	101	$ 74,940.99	02.Apr.2018								Raghu
14

“zMasterAfter1stConsolidationNewData.xlsm” : https://app.box.com/s/ascky2qg47dzl85b4y7l8sy5qmr3goby

Using Excel 2007 32 bit

_Row\^Col
A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

19

18
ABC18
$ 741.99

101

$ 74,940.99
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

20

19
ABC19
$ 55.00

22

$ 1,210.00
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

21

20
ABC20
$ 13.66

7

$ 95.62
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

22

21
ABC21
$ 12.99

5

$ 64.95
02.Apr.2018 Raghu

23

22
ABC22
$ 8.51

12

$ 102.12
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

24

23
ABC23
$ 7.22

62

$ 447.64
02.Apr.2018 Greg

25

24
ABC24
$ 3.99

35

$ 139.65
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

26

25
ABC25
$ 333.45

99

$ 33,011.55
02.Apr.2018 Raghu

27

26
ABC26
$ 11.99

1

$ 11.99
02.Apr.2018 John

28

27
ABC27
$ 741.99

101

$ 74,940.99
02.Apr.2018 Greg

29

28
ABC28
$ 55.00

22

$ 1,210.00
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

30

29
ABC29
$ 13.66

7

$ 95.62
02.Apr.2018 Raghu

31

30
ABC30
$ 12.99

5

$ 64.95
02.Apr.2018 John

32

31
ABC31
$ 8.51

12

$ 102.12
02.Apr.2018 Greg

33

32
ABC32
$ 7.22

62

$ 447.64
02.Apr.2018 Margaret

34

33
ABC33
$ 3.99

35

$ 139.65
02.Apr.2018 Raghu

35

34
ABC34
$ 333.45

99

$ 33,011.55
02.Apr.2018 John

36

35
ABC35
$ 11.99

1

$ 11.99
02.Apr.2018 Greg

37

36
ABC36
$ 741.99

101

$ 74,940.99
02.Apr.2018 Margaret

38

37
ABC37
$ 55.00

22

$ 1,210.00
02.Apr.2018 Raghu

39

38
ABC38
$ 13.66

7

$ 95.62
02.Apr.2018 John

40

39
ABC39
$ 12.99

5

$ 64.95
02.Apr.2018 Greg

41

40
ABC40
$ 8.51

12

$ 102.12
02.Apr.2018 Margaret

42

41
ABC41
$ 7.22

62

$ 447.64
02.Apr.2018 Raghu

43

42
ABC42
$ 3.99

35

$ 139.65
02.Apr.2018 John

44

43
ABC43
$ 333.45

99

$ 33,011.55
02.Apr.2018 Greg

45

44
ABC44
$ 11.99

1

$ 11.99
02.Apr.2018 Margaret

46

45
ABC45
$ 741.99

101

$ 74,940.99
02.Apr.2018 Raghu

47

46
ABC46
$ 8.51

12

$ 102.12
John

48

47
ABC47
$ 7.22

62

$ 447.64
Greg

49

48
ABC48
$ 3.99

35

$ 139.65
Margaret

50

49
ABC49
$ 333.45

99

$ 33,011.55
Raghu

51

50
ABC50
$ 11.99

1

$ 11.99
Raghu

52

Worksheet: OriginalData

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	N
19	18	ABC18	$ 741.99	101	$ 74,940.99	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018	John
20	19	ABC19	$ 55.00	22	$ 1,210.00	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018	Greg
21	20	ABC20	$ 13.66	7	$ 95.62	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018	Margaret
22	21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018							Raghu
23	22	ABC22	$ 8.51	12	$ 102.12	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018	John
24	23	ABC23	$ 7.22	62	$ 447.64	02.Apr.2018							Greg
25	24	ABC24	$ 3.99	35	$ 139.65	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018	Margaret
26	25	ABC25	$ 333.45	99	$ 33,011.55	02.Apr.2018							Raghu
27	26	ABC26	$ 11.99	1	$ 11.99	02.Apr.2018							John
28	27	ABC27	$ 741.99	101	$ 74,940.99	02.Apr.2018							Greg
29	28	ABC28	$ 55.00	22	$ 1,210.00	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018	Margaret
30	29	ABC29	$ 13.66	7	$ 95.62	02.Apr.2018							Raghu
31	30	ABC30	$ 12.99	5	$ 64.95	02.Apr.2018							John
32	31	ABC31	$ 8.51	12	$ 102.12	02.Apr.2018							Greg
33	32	ABC32	$ 7.22	62	$ 447.64	02.Apr.2018							Margaret
34	33	ABC33	$ 3.99	35	$ 139.65	02.Apr.2018							Raghu
35	34	ABC34	$ 333.45	99	$ 33,011.55	02.Apr.2018							John
36	35	ABC35	$ 11.99	1	$ 11.99	02.Apr.2018							Greg
37	36	ABC36	$ 741.99	101	$ 74,940.99	02.Apr.2018							Margaret
38	37	ABC37	$ 55.00	22	$ 1,210.00	02.Apr.2018							Raghu
39	38	ABC38	$ 13.66	7	$ 95.62	02.Apr.2018							John
40	39	ABC39	$ 12.99	5	$ 64.95	02.Apr.2018							Greg
41	40	ABC40	$ 8.51	12	$ 102.12	02.Apr.2018							Margaret
42	41	ABC41	$ 7.22	62	$ 447.64	02.Apr.2018							Raghu
43	42	ABC42	$ 3.99	35	$ 139.65	02.Apr.2018							John
44	43	ABC43	$ 333.45	99	$ 33,011.55	02.Apr.2018							Greg
45	44	ABC44	$ 11.99	1	$ 11.99	02.Apr.2018							Margaret
46	45	ABC45	$ 741.99	101	$ 74,940.99	02.Apr.2018							Raghu
47	46	ABC46	$ 8.51	12	$ 102.12								John
48	47	ABC47	$ 7.22	62	$ 447.64								Greg
49	48	ABC48	$ 3.99	35	$ 139.65								Margaret
50	49	ABC49	$ 333.45	99	$ 33,011.55								Raghu
51	50	ABC50	$ 11.99	1	$ 11.99								Raghu
52

Run Code Sub ExportByName() on data from last post

Results for Updated master Worksheet

Using Excel 2007 32 bit

_Row\^Col
A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

25

24
ABC24
$ 3.99

35

$ 139.65
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

26

25
ABC25
$ 333.45

99

$ 33,011.55
02.Apr.2018 Raghu

27

26
ABC26
$ 11.99

1

$ 11.99
02.Apr.2018 John

28

27
ABC27
$ 741.99

101

$ 74,940.99
02.Apr.2018 Greg

29

28
ABC28
$ 55.00

22

$ 1,210.00
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

30

29
ABC29
$ 13.66

7

$ 95.62
02.Apr.2018 Raghu

31

30
ABC30
$ 12.99

5

$ 64.95
02.Apr.2018 John

32

31
ABC31
$ 8.51

12

$ 102.12
02.Apr.2018 Greg

33

32
ABC32
$ 7.22

62

$ 447.64
02.Apr.2018 Margaret

34

33
ABC33
$ 3.99

35

$ 139.65
02.Apr.2018 Raghu

35

34
ABC34
$ 333.45

99

$ 33,011.55
02.Apr.2018 John

36

35
ABC35
$ 11.99

1

$ 11.99
02.Apr.2018 Greg

37

36
ABC36
$ 741.99

101

$ 74,940.99
02.Apr.2018 Margaret

38

37
ABC37
$ 55.00

22

$ 1,210.00
02.Apr.2018 Raghu

39

38
ABC38
$ 13.66

7

$ 95.62
02.Apr.2018 John

40

39
ABC39
$ 12.99

5

$ 64.95
02.Apr.2018 Greg

41

40
ABC40
$ 8.51

12

$ 102.12
02.Apr.2018 Margaret

42

41
ABC41
$ 7.22

62

$ 447.64
02.Apr.2018 Raghu

43

42
ABC42
$ 3.99

35

$ 139.65
02.Apr.2018 John

44

43
ABC43
$ 333.45

99

$ 33,011.55
02.Apr.2018 Greg

45

44
ABC44
$ 11.99

1

$ 11.99
02.Apr.2018 Margaret

46

45
ABC45
$ 741.99

101

$ 74,940.99
02.Apr.2018 Raghu

47

46
ABC46
$ 8.51

12

$ 102.12

02.Apr.2018
John

48

47
ABC47
$ 7.22

62

$ 447.64

02.Apr.2018
Greg

49

48
ABC48
$ 3.99

35

$ 139.65

02.Apr.2018
Margaret

50

49
ABC49
$ 333.45

99

$ 33,011.55

02.Apr.2018
Raghu

51

50
ABC50
$ 11.99

1

$ 11.99

02.Apr.2018
Raghu

52

53

54

Worksheet: OriginalData

Corresponding updated data worksheets for updated master after running Sub ExportByName() for the second time after new data was added

Using Excel 2007 32 bit

41
ABC41
$ 7.22

62

$ 447.64
02.Apr.2018 Raghu

45
ABC45
$ 741.99

101

$ 74,940.99
02.Apr.2018 Raghu

49
ABC49 $ 333.45
99
$ 33,011.55 02.Apr.2018 Raghu

50
ABC50 $ 11.99
1
$ 11.99 02.Apr.2018 Raghu

Worksheet: Tabelle1

Using Excel 2007 32 bit

40
ABC40
$ 8.51

12

$ 102.12
02.Apr.2018 Margaret

44
ABC44
$ 11.99

1

$ 11.99
02.Apr.2018 Margaret

48
ABC48 $ 3.99
35
$ 139.65 02.Apr.2018 Margaret

Worksheet: Tabelle1

Using Excel 2007 32 bit

38
ABC38
$ 13.66

7

$ 95.62
02.Apr.2018 John

42
ABC42
$ 3.99

35

$ 139.65
02.Apr.2018 John

46
ABC46 $ 8.51
12
$ 102.12 02.Apr.2018 John

Worksheet: Tabelle1

Using Excel 2007 32 bit

39
ABC39
$ 12.99

5

$ 64.95
02.Apr.2018 Greg

43
ABC43
$ 333.45

99

$ 33,011.55
02.Apr.2018 Greg

47
ABC47 $ 7.22
62
$ 447.64 02.Apr.2018 Greg

Worksheet: Tabelle1

Data Files just before second consolidation

15
ABC15
$ 3.99

35

$ 139.65
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

19
ABC19
$ 55.00

22

$ 1,210.00
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

23
ABC23
$ 7.22

62

$ 447.64
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 Greg

27
ABC27
$ 741.99

101

$ 74,940.99
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 Greg

31
ABC31
$ 8.51

12

$ 102.12
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 Greg

35
ABC35
$ 11.99

1

$ 11.99
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 Greg

39
ABC39
$ 12.99

5

$ 64.95
02.Apr.2018 Greg

Worksheet: Tabelle1

18
ABC18
$ 741.99

101

$ 74,940.99
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

22
ABC22
$ 8.51

12

$ 102.12
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

26
ABC26
$ 11.99

1

$ 11.99
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 John

30
ABC30
$ 12.99

5

$ 64.95
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 John

34
ABC34
$ 333.45

99

$ 33,011.55
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 John

38
ABC38
$ 13.66

7

$ 95.62
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 John

42
ABC42
$ 3.99

35

$ 139.65
02.Apr.2018 John

Worksheet: Tabelle1

28
ABC28
$ 55.00

22

$ 1,210.00
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

32
ABC32
$ 7.22

62

$ 447.64
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 Margaret

36
ABC36
$ 741.99

101

$ 74,940.99
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 Margaret

40
ABC40
$ 8.51

12

$ 102.12
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 Margaret

44
ABC44
$ 11.99

1

$ 11.99
02.Apr.2018 Margaret

Worksheet: Tabelle1

Using Excel 2007 32 bit

17
ABC17
$ 11.99

1

$ 11.99
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
02.Apr.2018 Raghu

21
ABC21
$ 12.99

5

$ 64.95
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
Raghu

25
ABC25
$ 333.45

99

$ 33,011.55
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
Raghu

29
ABC29
$ 13.66

7

$ 95.62
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
Raghu

33
ABC33
$ 3.99

35

$ 139.65
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
Raghu

37
ABC37
$ 55.00

22

$ 1,210.00
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
Raghu

41
ABC41
$ 7.22

62

$ 447.64
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
Raghu

45
ABC45
$ 741.99

101

$ 74,940.99
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
Raghu

49
ABC49 $ 333.45
99
$ 33,011.55 02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
Raghu

50
ABC50 $ 11.99
1
$ 11.99 02.Apr.2018 Raghu

Worksheet: Tabelle1

Final results for first half of master File after second consolidation

Using Excel 2007 32 bit

_Row\^Col
A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

1

S No

Item

Price

Qty

Total

Distributed

Task1

Task2

Task3

Task4

Completed

Consolidated

Comments

Team Member

Checked

2

1
ABC01
$ 55.00

22

$ 1,210.00
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

3

2
ABC02
$ 13.66

7

$ 95.62
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

4

3
ABC03
$ 12.99

5

$ 64.95
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

5

4
ABC04
$ 8.51

12

$ 102.12
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

6

5
ABC05
$ 7.22

62

$ 447.64
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

7

6
ABC06
$ 3.99

35

$ 139.65
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

8

7
ABC07
$ 333.45

99

$ 33,011.55
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

9

8
ABC08
$ 11.99

1

$ 11.99
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

10

9
ABC09
$ 741.99

101

$ 74,940.99
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

11

10
ABC10
$ 55.00

22

$ 1,210.00
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

12

11
ABC11
$ 13.66

7

$ 95.62
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

13

12
ABC12
$ 12.99

5

$ 64.95
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

14

13
ABC13
$ 8.51

12

$ 102.12
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

15

14
ABC14
$ 7.22

62

$ 447.64
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

16

15
ABC15
$ 3.99

35

$ 139.65
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

17

16
ABC16
$ 333.45

99

$ 33,011.55
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

18

17
ABC17
$ 11.99

1

$ 11.99
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

19

18
ABC18
$ 741.99

101

$ 74,940.99
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

20

19
ABC19
$ 55.00

22

$ 1,210.00
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

21

20
ABC20
$ 13.66

7

$ 95.62
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

22

21
ABC21
$ 12.99

5

$ 64.95
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

23

22
ABC22
$ 8.51

12

$ 102.12
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

24

23
ABC23
$ 7.22

62

$ 447.64
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

25

24
ABC24
$ 3.99

35

$ 139.65
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

26

25
ABC25
$ 333.45

99

$ 33,011.55
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

Worksheet: OriginalData

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member	Checked
2	1	ABC01	$ 55.00	22	$ 1,210.00	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
3	2	ABC02	$ 13.66	7	$ 95.62	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
4	3	ABC03	$ 12.99	5	$ 64.95	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
5	4	ABC04	$ 8.51	12	$ 102.12	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
6	5	ABC05	$ 7.22	62	$ 447.64	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
7	6	ABC06	$ 3.99	35	$ 139.65	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
8	7	ABC07	$ 333.45	99	$ 33,011.55	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
9	8	ABC08	$ 11.99	1	$ 11.99	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
10	9	ABC09	$ 741.99	101	$ 74,940.99	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
11	10	ABC10	$ 55.00	22	$ 1,210.00	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
12	11	ABC11	$ 13.66	7	$ 95.62	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
13	12	ABC12	$ 12.99	5	$ 64.95	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
14	13	ABC13	$ 8.51	12	$ 102.12	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
15	14	ABC14	$ 7.22	62	$ 447.64	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
16	15	ABC15	$ 3.99	35	$ 139.65	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
17	16	ABC16	$ 333.45	99	$ 33,011.55	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
18	17	ABC17	$ 11.99	1	$ 11.99	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
19	18	ABC18	$ 741.99	101	$ 74,940.99	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
20	19	ABC19	$ 55.00	22	$ 1,210.00	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
21	20	ABC20	$ 13.66	7	$ 95.62	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
22	21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
23	22	ABC22	$ 8.51	12	$ 102.12	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
24	23	ABC23	$ 7.22	62	$ 447.64	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
25	24	ABC24	$ 3.99	35	$ 139.65	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
26	25	ABC25	$ 333.45	99	$ 33,011.55	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu

Second half of master worksheet after final second consolidation

Using Excel 2007 32 bit

_Row\^Col
A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

25

24
ABC24
$ 3.99

35

$ 139.65
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

26

25
ABC25
$ 333.45

99

$ 33,011.55
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

27

26
ABC26
$ 11.99

1

$ 11.99
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

28

27
ABC27
$ 741.99

101

$ 74,940.99
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

29

28
ABC28
$ 55.00

22

$ 1,210.00
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

30

29
ABC29
$ 13.66

7

$ 95.62
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

31

30
ABC30
$ 12.99

5

$ 64.95
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

32

31
ABC31
$ 8.51

12

$ 102.12
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

33

32
ABC32
$ 7.22

62

$ 447.64
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

34

33
ABC33
$ 3.99

35

$ 139.65
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

35

34
ABC34
$ 333.45

99

$ 33,011.55
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

36

35
ABC35
$ 11.99

1

$ 11.99
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

37

36
ABC36
$ 741.99

101

$ 74,940.99
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

38

37
ABC37
$ 55.00

22

$ 1,210.00
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

39

38
ABC38
$ 13.66

7

$ 95.62
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

40

39
ABC39
$ 12.99

5

$ 64.95
02.Apr.2018 Greg

41

40
ABC40
$ 8.51

12

$ 102.12
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

42

41
ABC41
$ 7.22

62

$ 447.64
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

43

42
ABC42
$ 3.99

35

$ 139.65
02.Apr.2018 John

44

43
ABC43
$ 333.45

99

$ 33,011.55
02.Apr.2018 Greg

45

44
ABC44
$ 11.99

1

$ 11.99
02.Apr.2018 Margaret

46

45
ABC45
$ 741.99

101

$ 74,940.99
02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

47

46
ABC46
$ 8.51

12

$ 102.12

02.Apr.2018
John

48

47
ABC47
$ 7.22

62

$ 447.64

02.Apr.2018
Greg

49

48
ABC48
$ 3.99

35

$ 139.65

02.Apr.2018
Margaret

50

49
ABC49
$ 333.45

99

$ 33,011.55

02.Apr.2018
RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

51

50
ABC50
$ 11.99

1

$ 11.99

02.Apr.2018
Raghu

52

Worksheet: OriginalData

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	N
25	24	ABC24	$ 3.99	35	$ 139.65	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018	Margaret
26	25	ABC25	$ 333.45	99	$ 33,011.55	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018	Raghu
27	26	ABC26	$ 11.99	1	$ 11.99	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018	John
28	27	ABC27	$ 741.99	101	$ 74,940.99	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018	Greg
29	28	ABC28	$ 55.00	22	$ 1,210.00	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018	Margaret
30	29	ABC29	$ 13.66	7	$ 95.62	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018	Raghu
31	30	ABC30	$ 12.99	5	$ 64.95	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018	John
32	31	ABC31	$ 8.51	12	$ 102.12	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018	Greg
33	32	ABC32	$ 7.22	62	$ 447.64	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018	Margaret
34	33	ABC33	$ 3.99	35	$ 139.65	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018	Raghu
35	34	ABC34	$ 333.45	99	$ 33,011.55	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018	John
36	35	ABC35	$ 11.99	1	$ 11.99	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018	Greg
37	36	ABC36	$ 741.99	101	$ 74,940.99	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018	Margaret
38	37	ABC37	$ 55.00	22	$ 1,210.00	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018	Raghu
39	38	ABC38	$ 13.66	7	$ 95.62	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018	John
40	39	ABC39	$ 12.99	5	$ 64.95	02.Apr.2018							Greg
41	40	ABC40	$ 8.51	12	$ 102.12	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018	Margaret
42	41	ABC41	$ 7.22	62	$ 447.64	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018	Raghu
43	42	ABC42	$ 3.99	35	$ 139.65	02.Apr.2018							John
44	43	ABC43	$ 333.45	99	$ 33,011.55	02.Apr.2018							Greg
45	44	ABC44	$ 11.99	1	$ 11.99	02.Apr.2018							Margaret
46	45	ABC45	$ 741.99	101	$ 74,940.99	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018	Raghu
47	46	ABC46	$ 8.51	12	$ 102.12	02.Apr.2018							John
48	47	ABC47	$ 7.22	62	$ 447.64	02.Apr.2018							Greg
49	48	ABC48	$ 3.99	35	$ 139.65	02.Apr.2018							Margaret
50	49	ABC49	$ 333.45	99	$ 33,011.55	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018	Raghu
51	50	ABC50	$ 11.99	1	$ 11.99	02.Apr.2018							Raghu
52

Data files after final (second) consolidation:

Using Excel 2007 32 bit

15
ABC15
$ 3.99

35

$ 139.65
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

19
ABC19
$ 55.00

22

$ 1,210.00
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

23
ABC23
$ 7.22

62

$ 447.64
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

27
ABC27
$ 741.99

101

$ 74,940.99
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

31
ABC31
$ 8.51

12

$ 102.12
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

35
ABC35
$ 11.99

1

$ 11.99
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg

39
ABC39
$ 12.99

5

$ 64.95
02.Apr.2018 Greg

Worksheet: Tabelle1

Using Excel 2007 32 bit

_Row\^Col
A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

11

37
ABC37
$ 55.00

22

$ 1,210.00
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
02.Apr.2018 Raghu

12

41
ABC41
$ 7.22

62

$ 447.64
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
02.Apr.2018 Raghu

13

45
ABC45
$ 741.99

101

$ 74,940.99
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
02.Apr.2018 Raghu

14

49
ABC49
333.45 €

99

33,011.55 €
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
02.Apr.2018 Raghu

15

50
ABC50
11.99 €

1

11.99 €
02.Apr.2018 Raghu

16

Worksheet: Tabelle1

Using Excel 2007 32 bit

28
ABC28
$ 55.00

22

$ 1,210.00
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

32
ABC32
$ 7.22

62

$ 447.64
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

36
ABC36
$ 741.99

101

$ 74,940.99
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

40
ABC40
$ 8.51

12

$ 102.12
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret

44
ABC44
$ 11.99

1

$ 11.99
02.Apr.2018 Margaret

48
ABC48
3.99 €

35

139.65 €
02.Apr.2018 Margaret

Worksheet: Tabelle1

Using Excel 2007 32 bit

26
ABC26
$ 11.99

1

$ 11.99
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

30
ABC30
$ 12.99

5

$ 64.95
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

34
ABC34
$ 333.45

99

$ 33,011.55
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

38
ABC38
$ 13.66

7

$ 95.62
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John

42
ABC42
$ 3.99

35

$ 139.65
02.Apr.2018 John

Worksheet: Tabelle1

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	N
11	37	ABC37	$ 55.00	22	$ 1,210.00	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018	Raghu
12	41	ABC41	$ 7.22	62	$ 447.64	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018	Raghu
13	45	ABC45	$ 741.99	101	$ 74,940.99	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018	Raghu
14	49	ABC49	333.45 €	99	33,011.55 €	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018	Raghu
15	50	ABC50	11.99 €	1	11.99 €	02.Apr.2018							Raghu
16

Code for anwser to this Thread:
http://www.excelfox.com/forum/showth...e-folder/page2

Code:

Option Explicit Sub consolidateToo() ' http://www.excelfox.com/forum/showthread.php/2238-Copy-data-from-Unique-files-into-Masterfile-all-the-files-in-the-same-folder?p=10595#post10595 Rem 1 ThisWorkbook Info Dim MWs1 As Worksheet: Set MWs1 = ThisWorkbook.Worksheets.Item(1) 'Worksheets("OriginalData") Dim DtaFName As String: Let DtaFName = VBA.Dir(ThisWorkbook.Path & "\" & "*.xlsx") ' Search criteria set to all Files with .xlsx extension in the same Folder as this workbook, Dir returns first file name that fits criteria Dim LrMWs1 As Long: Let LrMWs1 = MWs1.Range("A" & MWs1.Rows.Count & "").End(xlUp).Row Rem 2 main Loop for all data files Do While DtaFName <> "" ' ========================================== Workbooks.Open filename:=ThisWorkbook.Path & "\" & DtaFName Dim WBDta As Workbook: Set WBDta = ActiveWorkbook Dim WBDtaWs1 As Worksheet: Set WBDtaWs1 = WBDta.Worksheets.Item(1) ' use variable to reference the first worksheet ( counting tabs from the left ) of last opened and therefore active( to be seen ) file Dim arrIn() As Variant: Let arrIn() = WBDtaWs1.Range("A1").CurrentRegion.Value '2a) loop for all data rows, copy data from completed rows to master file, ( add date to inputed data array '_-##) Dim Rw As Long ' -------------------------------- For Rw = 2 To UBound(arrIn(), 1) ' loop through "rows" in data array If arrIn(Rw, 11) <> Empty And arrIn(Rw, 12) = Empty Then ' Condition for completed work not yet consolidated Dim arrCsDte(1 To 1, 1 To 7) As String: Let arrCsDte(1, 1) = arrIn(Rw, 7): arrCsDte(1, 2) = arrIn(Rw, 8): arrCsDte(1, 3) = arrIn(Rw, 9): arrCsDte(1, 4) = arrIn(Rw, 10): arrCsDte(1, 5) = arrIn(Rw, 11): arrCsDte(1, 6) = Format(Date, "dd.mmm.yyyy"): arrCsDte(1, 7) = arrIn(Rw, 13) ' 7 "columns" of data to be added to master file MWs1.Range("A2:A" & LrMWs1 & "").Find(what:=arrIn(Rw, 1), After:=MWs1.Range("A2"), LookIn:=xlValues, Lookat:=xlWhole, searchorder:=xlByRows, searchdirection:=xlNext).Offset(0, 6).Resize(1, 7) = arrCsDte() ' We look down the first column in the master file to find the cell comtaining the S No We apply the offest property to thast cell to get across to column G and then the resize property gives us the range of 7 columns to which we may apply the values in the array filled for the row data Let arrIn(Rw, 12) = arrCsDte(1, 6) '(Put the current date in the array made from data range '_-##) Else ' Datá row is completed and consolidated , so nothing to do for this row End If Next Rw ' End loop for all data rows -------- '2b) Update and close current data workbook Let WBDtaWs1.Range("A1").Resize(UBound(arrIn(), 1), UBound(arrIn(), 2)).Value = arrIn() ' reassign the values from the input data array back to the range as this now has the consolidated date in it WBDta.Close savechanges:=True '2c Serch for next data file name Let DtaFName = VBA.Dir() ' Unqualified Dir returns next found file with previos search criteria, but only returns each file name once Loop ' Do While DtaFName <> "" again ============================== End Sub

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxzpgHWTLGj0C3q3gx4AaABAg. 9gxsUMU53al9k5c8W6QGE8
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg. 9gxDYq2iiZ89h4ISxLD17d
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg. 9gxDYq2iiZ89h4LdsDETim
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg. 9gxDYq2iiZ89h32czjtyR_
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxzpgHWTLGj0C3q3gx4AaABAg
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugw_smEwvNffCPr_nrB4AaABAg. 9gvyL53lI1l9gxwd_9-V6z
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugy7vmiHsQ0oUt2QCPZ4AaABAg. 9gvoy4OW6lU9gxwxC5-rL9
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgzuX3uYmqJRtsZIbqF4AaABAg. 9gth61YhXKB9gxxCMdRLA0
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxcPC64RQGmXwO5rft4AaABAg. 9gtQLXaeg0e9gxxNuc5CCM
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwCY8vOs1DFHgYSJwF4AaABAg. 9godrFcyWYw9gxy1odpiRj
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgyL5nh_j8w70-YBoUt4AaABAg.9goMcRjwjtc9gxyslvuZKx
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwwWRgmRZNqJKptHR14AaABAg. 9go-DbayTZa9gxzPbefHXf
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwF3wECwc8tVoRmz6B4AaABAg. 9go-5xLQM8P9gxzmB7nkVQ
https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgyRDmGTHnMdT7dl_qx4AaABAg
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA