From last post...

This could be a typical returned worksheet from a team member : ( based on similar files in the Zip Folder "WorkDistributedAndConsolidated 16MAR18.zip" )
Using Excel 2007 32 bit
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
15. Mrz 18
RT1 RT2 RT3 RT4
02. Apr 18
Raghu
3
5
ABC05
$ 7.22
62
$ 447.64
15. Mrz 18
RT1 RT2 RT3 RT4
02. Apr 18
Raghu
4
9
ABC09
$ 741.99
101
$ 74,940.99
15. Mrz 18
RT1 RT2 RT3 RT4
02. Apr 18
Raghu
5
13
ABC13
$ 8.51
12
$ 102.12
15. Mrz 18
RT1 RT2 RT3 RT4
02. Apr 18
Raghu
6
17
ABC17
$ 11.99
1
$ 11.99
15. Mrz 18
RT1 RT2 RT3 RT4
02. Apr 18
Raghu
7
21
ABC21
$ 12.99
5
$ 64.95
15. Mrz 18
Raghu
8
25
ABC25
$ 333.45
99
$ 33,011.55
15. Mrz 18
Raghu
9
29
ABC29
$ 13.66
7
$ 95.62
15. Mrz 18
Raghu
10
33
ABC33
$ 3.99
35
$ 139.65
15. Mrz 18
Raghu
11
37
ABC37
$ 55.00
22
$ 1,210.00
15. Mrz 18
Raghu
12
41
ABC41
$ 7.22
62
$ 447.64
15. Mrz 18
Raghu
13
45
ABC45
$ 741.99
101
$ 74,940.99
15. Mrz 18
Raghu
Worksheet: FromRaghu

or this
Using Excel 2007 32 bit
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
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
Worksheet: Tabelle1