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

[DocAElstein]

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.9irLgSdeU3r9itU7zdnW Hw
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.9ht16tzryC49htJ6TpIO XR
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgwMKwGZpDjv7vi7pCx4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg.9ht16tzryC49htOKs4jh 3M
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgxVW-am20rQ5GFuJ9F4AaABAg
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[DocAElstein]

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

[DocAElstein]

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.

[DocAElstein]

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" )

[DocAElstein]

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

[DocAElstein]

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

[DocAElstein]

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

[DocAElstein]

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

[DocAElstein]

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

[DocAElstein]

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