From last Post... master File After Distribition and before Consolidation
File: “zMasterBeforeConsolidation.xlsm”
https://app.box.com/s/818q2ev3owpini2202n3dqp3xxicfeif

S No
Item
Price
Qty
Total
Distributed
Task1
Task2
Task3
Task4
Completed
Consolidated
Comments
Team Member
Checked
1
 ABC01
$ 55.00
22
$ 1,210.00
02.Apr.2018 Raghu
2
 ABC02
$ 13.66
7
$ 95.62
02.Apr.2018 John
3
 ABC03
$ 12.99
5
$ 64.95
02.Apr.2018 Greg
4
 ABC04
$ 8.51
12
$ 102.12
02.Apr.2018 Margaret
5
 ABC05
$ 7.22
62
$ 447.64
02.Apr.2018 Raghu
6
 ABC06
$ 3.99
35
$ 139.65
02.Apr.2018 John
7
 ABC07
$ 333.45
99
$ 33,011.55
02.Apr.2018 Greg
8
 ABC08
$ 11.99
1
$ 11.99
02.Apr.2018 Margaret
9
 ABC09
$ 741.99
101
$ 74,940.99
02.Apr.2018 Raghu
10
 ABC10
$ 55.00
22
$ 1,210.00
02.Apr.2018 John
11
 ABC11
$ 13.66
7
$ 95.62
02.Apr.2018 Greg
12
 ABC12
$ 12.99
5
$ 64.95
02.Apr.2018 Margaret
13
 ABC13
$ 8.51
12
$ 102.12
02.Apr.2018 Raghu
14
 ABC14
$ 7.22
62
$ 447.64
02.Apr.2018 John
15
 ABC15
$ 3.99
35
$ 139.65
02.Apr.2018 Greg
16
 ABC16
$ 333.45
99
$ 33,011.55
02.Apr.2018 Margaret
17
 ABC17
$ 11.99
1
$ 11.99
02.Apr.2018 Raghu
18
 ABC18
$ 741.99
101
$ 74,940.99
02.Apr.2018 John
19
 ABC19
$ 55.00
22
$ 1,210.00
02.Apr.2018 Greg
20
 ABC20
$ 13.66
7
$ 95.62
02.Apr.2018 Margaret
21
 ABC21
$ 12.99
5
$ 64.95
02.Apr.2018 Raghu
22
 ABC22
$ 8.51
12
$ 102.12
02.Apr.2018 John
23
 ABC23
$ 7.22
62
$ 447.64
02.Apr.2018 Greg
24
 ABC24
$ 3.99
35
$ 139.65
02.Apr.2018 Margaret
25
 ABC25
$ 333.45
99
$ 33,011.55
02.Apr.2018 Raghu
26
 ABC26
$ 11.99
1
$ 11.99
02.Apr.2018 John
27
 ABC27
$ 741.99
101
$ 74,940.99
02.Apr.2018 Greg
28
 ABC28
$ 55.00
22
$ 1,210.00
02.Apr.2018 Margaret
29
 ABC29
$ 13.66
7
$ 95.62
02.Apr.2018 Raghu
30
 ABC30
$ 12.99
5
$ 64.95
02.Apr.2018 John
31
 ABC31
$ 8.51
12
$ 102.12
02.Apr.2018 Greg
32
 ABC32
$ 7.22
62
$ 447.64
02.Apr.2018 Margaret
33
 ABC33
$ 3.99
35
$ 139.65
02.Apr.2018 Raghu
34
 ABC34
$ 333.45
99
$ 33,011.55
02.Apr.2018 John
35
 ABC35
$ 11.99
1
$ 11.99
02.Apr.2018 Greg
36
 ABC36
$ 741.99
101
$ 74,940.99
02.Apr.2018 Margaret
37
 ABC37
$ 55.00
22
$ 1,210.00
02.Apr.2018 Raghu
38
 ABC38
$ 13.66
7
$ 95.62
02.Apr.2018 John
39
 ABC39
$ 12.99
5
$ 64.95
02.Apr.2018 Greg
40
 ABC40
$ 8.51
12
$ 102.12
02.Apr.2018 Margaret
41
 ABC41
$ 7.22
62
$ 447.64
02.Apr.2018 Raghu
42
 ABC42
$ 3.99
35
$ 139.65
02.Apr.2018 John
43
 ABC43
$ 333.45
99
$ 33,011.55
02.Apr.2018 Greg
44
 ABC44
$ 11.99
1
$ 11.99
02.Apr.2018 Margaret
45
 ABC45
$ 741.99
101
$ 74,940.99
02.Apr.2018 Raghu
Worksheet: OriginalData