P2P Cloud DVR remote Access via a (remote) PC Using Guarding Vision PC Client Software

Working Examples

hkjahhdahdhdh

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=SIDLFRkUEIo&lc=UgzTF5vvB67Zbfs9qvx4AaABAg
https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxLtKj969oiIu7zNb94AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=Ugx12mI-a39T41NaZ8F4AaABAg.9iDQqIP56NV9iFD0AkeeJG
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg. 9irLgSdeU3r9itU7zdnWHw
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgzFkoI0n_BxwnwVMcZ4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg.9htChVuaX9W9htG01cKBzX
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg. 9ht16tzryC49htJ6TpIOXR
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgwMKwGZpDjv7vi7pCx4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg. 9ht16tzryC49htOKs4jh3M
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgxVW-am20rQ5GFuJ9F4AaABAg
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

Using this File:
“UpdatesOnVistaAspire4810TZG25thMarch.txt” : https://app.box.com/s/z90o8yj7iz0188yci34mu7gahe2tfhce
That file is downloaded into the same Folder as the file containing the code from the last Post.
This code line needs to have that text file reference in it such:
Let ActiviEL = ThisWorkbook.Path & "\UpdatesOnVistaAspire4810TZG25thMarch.txt"
Run code entering these search values when prompted
2553154 2726958 2965291 2920813 3054873 974554

Here the output string

You looked for
2553154
2726958
2965291
2920813
3054873
974554

Finded was

_.______________________________________________

Using this File:
“UpdatesAcerMartinWin7Pro64Bit26thMarch.txt” : https://app.box.com/s/8m96l0e7yh1wcb15y06eaaz6a7vtjzgd
That file is downloaded into the same Folder as the file containing the code from the last Post.
This code line needs to have that text file reference in it such:
Let ActiviEL = ThisWorkbook.Path & "\“UpdatesAcerMartinWin7Pro64Bit26thMarch.txt"
Run code entering these search values when prompted
2553154 2726958 2965291 2920813 3054873 974554

Here the output string

You looked for
2553154
2726958
2965291
2920813
3054873
974554

Finded was

5 Attachment(s)

Finding and deleteing .exd files

Appendix notes in support of these Threads:
http://www.excelfox.com/forum/showth...en-insert-them
http://www.excelfox.com/forum/showth...ommand-Buttons

Trying to find .exd files and delete them.
The results of most of what I have read or results of asking people suggests that they are usually findable if you look for a temp or temp somewhere in a file path

These appear a bit difficult to find sometimes . You can try:

_ manually navigating

_ a windows explorer search for *.exd
StarDotexeExplorerSearch.JPG : https://imgur.com/hfbC93Z
Attachment 2037

_ a search in a small bar using %temp% or %Temp%
You can get the small bar from either hitting WindowsKey+r or by selecting the Windows symbol
PerCenttempPerCentsearch.JPG : https://imgur.com/LypHLGY
Attachment 2038
PerCenttempPerCentsearch2.jpg : https://imgur.com/DZvycco
Attachment 2039

It seems a bit inconsistent which search finds what, but usually it is said that you find important places looking something like these:
C:\Users\username\AppData\Local\Temp\Excel8.0
C:\Users\username\AppData\Local\Temp\VBE

I found sometimes .exd files here also
C:\Users\username\Application Data\Microsoft\Forms

Some other typical places I found
C:\Dokumente und Einstellungen\Administrator\Application Data\Microsoft\Forms
C:\Dokumente und Einstellungen\Administrator\AppData\LocalLow

_.____._____________________

This is one of my typical attempts to get a ActiveX control button to_... either
_ insert into worksheet
or , if already three
_ work
_... by deleting .exd files

What I typically tried:
I looked here C:\Users\Elston\AppData\Local\Temp\Excel8.0
I found this:
C Users Elston AppData Local Temp Excel8.0.jpg https://imgur.com/doXstmr
Attachment 2040

I deleted that MSForms.exd File ( Excel had to be closed to do that ) : It had no effect. ( By the way, MSForms.exd gets made again every time I hit the button, or it appears to get made as soon as I open any file that either has or has ever had a control embedded in a worksheet)

In C:\Users\Elston\AppData\Local\Temp\VBE I found these:
C Users Elston AppData Local Temp VBE.jpg https://imgur.com/wjaZpXp
Attachment 2041

So…for these files I did:…
MSComctlLib.exd : I deleted this , - no effect
MSForms.exd : This could not be deleted with Excel 2003 open, it can when it is closed. But that had no effect
RefEdit.exd : This could not be deleted with Excel 2003 open, it can when it is closed. But no that had effect
( By the way, MSForms.exd and RefEdit.exd get made again every time I hit the button, or it appears to get made as soon as I open any file that either has, or has ever had, a control embedded in a worksheet )

In C:\Users\Elston\Application Data\Microsoft\Forms
I found these:
( https://imgur.com/Lv2kyhk )

So……for these files I did:…
RefEdit.exd This could not be deleted with Excel 2003 open, it can when it is closed. But that had no effect
mscomctllib.exd I deleted this: That had no effect
SHDocVw.exd I deleted this: That had no effect
( By the way, MSForms.exd gets made again every time I hit the button, or it appears to get made as soon as I open any file that either has or has ever had a control embedded in a worksheet)

_.._______________-

So for me none of that helped to get me a working ActiveX control Button in a worksheet.

:(

Screenshots and extra notes in support of this Thread:
http://www.excelfox.com/forum/showth...0595#post10595

Distributed Files for the day for "Raghu.xlsx"
From Raghu
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
Raghu

3

5
ABC05
$ 7.22

62

$ 447.64

15. Mrz 18
Raghu

4

9
ABC09
$ 741.99

101

$ 74,940.99

15. Mrz 18
Raghu

5

13
ABC13
$ 8.51

12

$ 102.12

15. Mrz 18
Raghu

6

17
ABC17
$ 11.99

1

$ 11.99

15. Mrz 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 if distributed today, 2nd April
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 Raghu

3

5
ABC05
$ 7.22

62

$ 447.64
02.Apr.2018 Raghu

4

9
ABC09
$ 741.99

101

$ 74,940.99
02.Apr.2018 Raghu

5

13
ABC13
$ 8.51

12

$ 102.12
02.Apr.2018 Raghu

6

17
ABC17
$ 11.99

1

$ 11.99
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

Worksheet: Tabelle1

_.________________________

In next Post could be a typical returned worksheet from a team member : ( based on similar files in the Zip Folder "WorkDistributedAndConsolidated 16MAR18.zip" )

_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								Raghu
3	5	ABC05	$ 7.22	62	$ 447.64	15. Mrz 18								Raghu
4	9	ABC09	$ 741.99	101	$ 74,940.99	15. Mrz 18								Raghu
5	13	ABC13	$ 8.51	12	$ 102.12	15. Mrz 18								Raghu
6	17	ABC17	$ 11.99	1	$ 11.99	15. Mrz 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

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

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

_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

_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

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

_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

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

Master File After First Consolidation

Using Excel 2007 32 bit

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 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu

2
ABC02
$ 13.66

7

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

3
ABC03
$ 12.99

5

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

4
ABC04
$ 8.51

12

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

5
ABC05
$ 7.22

62

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

6
ABC06
$ 3.99

35

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

7
ABC07
$ 333.45

99

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

8
ABC08
$ 11.99

1

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

9
ABC09
$ 741.99

101

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

10
ABC10
$ 55.00

22

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

11
ABC11
$ 13.66

7

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

12
ABC12
$ 12.99

5

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

13
ABC13
$ 8.51

12

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

14
ABC14
$ 7.22

62

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

15
ABC15
$ 3.99

35

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

16
ABC16
$ 333.45

99

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

17
ABC17
$ 11.99

1

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

18
ABC18
$ 741.99

101

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

19
ABC19
$ 55.00

22

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

20
ABC20
$ 13.66

7

$ 95.62
02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 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 JT1 JT2 JT3 JT4 02.Apr.2018 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 MT1 MT2 MT3 MT4 02.Apr.2018 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 MT1 MT2 MT3 MT4 02.Apr.2018 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

Some similar results to the last from previous post
These are from a File supplied by Raghu

S No

Item

Price

Qty

Total

Distributed

Task1

Task2

Task3

Task4

Completed

Consolidated

Comments

Team Member

1
ABC01
$ 55.00

22

$ 1,210.00

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

16. Mrz 18
Raghu

2
ABC02
$ 13.66

7

$ 95.62

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

16. Mrz 18
John

3
ABC03
$ 12.99

5

$ 64.95

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

16. Mrz 18
Greg

4
ABC04
$ 8.51

12

$ 102.12

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

16. Mrz 18
Margaret

5
ABC05
$ 7.22

62

$ 447.64

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

16. Mrz 18
Raghu

6
ABC06
$ 3.99

35

$ 139.65

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

16. Mrz 18
John

7
ABC07
$ 333.45

99

$ 33,011.55

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

16. Mrz 18
Greg

8
ABC08
$ 11.99

1

$ 11.99

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

16. Mrz 18
Margaret

9
ABC09
$ 741.99

101

$ 74,940.99

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

16. Mrz 18
Raghu

10
ABC10
$ 55.00

22

$ 1,210.00

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

16. Mrz 18
John

11
ABC11
$ 13.66

7

$ 95.62

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

16. Mrz 18
Greg

12
ABC12
$ 12.99

5

$ 64.95

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

16. Mrz 18
Margaret

13
ABC13
$ 8.51

12

$ 102.12

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

16. Mrz 18
Raghu

14
ABC14
$ 7.22

62

$ 447.64

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

16. Mrz 18
John

15
ABC15
$ 3.99

35

$ 139.65

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

16. Mrz 18
Greg

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

Worksheet: OriginalData

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

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

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