For this Post
http://www.excelfox.com/forum/showth...0595#post10595

Daily data files completed by team members:
John
S No
Item
Price
Qty
Total
Distributed
Task1
Task2
Task3
Task4
Completed
Consolidated
2
 ABC02
$ 13.66
7
$ 95.62
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018
6
 ABC06
$ 3.99
35
$ 139.65
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018
10
 ABC10
$ 55.00
22
$ 1,210.00
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018
14
 ABC14
$ 7.22
62
$ 447.64
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018
18
 ABC18
$ 741.99
101
$ 74,940.99
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018
22
 ABC22
$ 8.51
12
$ 102.12
02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018
26
 ABC26
$ 11.99
1
$ 11.99
02.Apr.2018
Worksheet: Tabelle1

Greg
3
 ABC03
$ 12.99
5
$ 64.95
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018
7
 ABC07
$ 333.45
99
$ 33,011.55
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018
11
 ABC11
$ 13.66
7
$ 95.62
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018
15
 ABC15
$ 3.99
35
$ 139.65
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018
19
 ABC19
$ 55.00
22
$ 1,210.00
02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018
23
 ABC23
$ 7.22
62
$ 447.64
02.Apr.2018
Worksheet: Tabelle1

Margret
4
 ABC04
$ 8.51
12
$ 102.12
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
8
 ABC08
$ 11.99
1
$ 11.99
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
12
 ABC12
$ 12.99
5
$ 64.95
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
16
 ABC16
$ 333.45
99
$ 33,011.55
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
20
 ABC20
$ 13.66
7
$ 95.62
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
24
 ABC24
$ 3.99
35
$ 139.65
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
28
 ABC28
$ 55.00
22
$ 1,210.00
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
32
 ABC32
$ 7.22
62
$ 447.64
02.Apr.2018
Worksheet: Tabelle1


Raghu
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
 Raghu
3
5
 ABC05
$ 7.22
62
$ 447.64
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
 Raghu
4
9
 ABC09
$ 741.99
101
$ 74,940.99
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
 Raghu
5
13
 ABC13
$ 8.51
12
$ 102.12
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
 Raghu
6
17
 ABC17
$ 11.99
1
$ 11.99
02.Apr.2018 RT1 RT2 RT3 RT4
02. Apr 18
 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
Worksheet: Tabelle1