Page 3 of 56 FirstFirst 123451353 ... LastLast
Results 21 to 30 of 554

Thread: Tests Copying pasting Cliipboard issues. and otes on API stuff

  1. 03-29-2018, 04:13 PM #21
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,458
    Rep Power
    10
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    ps://www.youtube.com/watch?v=TW3l7PkSPD4&lc=UgwAL_Jrv7yg7WWC8x14AaABAg
    https://teylyn.com/2017/03/21/dollarsigns/#comment-191
    https://stackoverflow.com/questions/33868233/shell-namespace-not-accepting-string-variable-but-accepting-string-itself/77888851#77888851
    https://microsoft.public.access.narkive.com/Jl55mts5/problem-using-shell-namespace-method-in-vba#post5
    https://stackoverflow.com/questions/77220774/getfolder-method-does-not-return-folder-object-it-returns-a-string-instead/77846716#77846716
    https://www.youtube.com/watch?v=zHJPliWS9FQ&lc=Ugz39PGfytiMUCmTPTl4AaABAg.91d_Pbzklsp9zfGbIr8h gW
    https://www.youtube.com/watch?v=zHJPliWS9FQ&lc=UgwbcybM8fXnaIK-Y3B4AaABAg.97WIeYeaIeh9zfsJvc21iq
    https://stackoverflow.com/questions/77220774/getfolder-method-does-not-return-folder-object-it-returns-a-string-instead/77846716#77846716
    https://www.youtube.com/watch?v=vSjTzhoJFdk&lc=UgzTC8V4jCzDHbmfCHF4AaABAg.9zaUSUoUUYs9zciSZa95 9d
    https://www.youtube.com/watch?v=vSjTzhoJFdk&lc=UgzTC8V4jCzDHbmfCHF4AaABAg.9zaUSUoUUYs9zckCo1tv PO
    https://www.youtube.com/watch?v=vSjTzhoJFdk&lc=UgwMsgdKKlhr2YPpxXl4AaABAg
    https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgwTUdEgR4bdt6crKXF4AaABAg.9xmkXGSciKJ9xonTti2s Ix
    https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgwWw16qBFX39JCRRm54AaABAg.9xnskBhPnmb9xoq3mGxu _b
    https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgzgWvzV-kvC4TJ8O414AaABAg.9xnFzCj8HRM9xon1p2ImxO
    https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgybZfNJd3l4FokX3cV4AaABAg.9xm_ufqOILb9xooIlv5P LY
    https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgzgWvzV-kvC4TJ8O414AaABAg.9xnFzCj8HRM9y38bzbSqaG
    https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgyWm8nL7syjhiHtpBF4AaABAg.9xmt8i0IsEr9y3FT9Y9F eM
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 10-28-2024 at 12:43 PM.
    Reply With Quote Reply With Quote
  2. 04-02-2018, 02:00 PM #22
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,458
    Rep Power
    10
    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" )
    A Folk, A Forum, A Fuhrer ….
    Reply With Quote Reply With Quote
  3. 04-02-2018, 02:01 PM #23
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,458
    Rep Power
    10
    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
    A Folk, A Forum, A Fuhrer ….
    Reply With Quote Reply With Quote
  4. 04-02-2018, 02:26 PM #24
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,458
    Rep Power
    10
    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
    A Folk, A Forum, A Fuhrer ….
    Reply With Quote Reply With Quote
  5. 04-02-2018, 03:16 PM #25
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,458
    Rep Power
    10
    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
    A Folk, A Forum, A Fuhrer ….
    Reply With Quote Reply With Quote
  6. 04-02-2018, 05:28 PM #26
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,458
    Rep Power
    10

    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
    A Folk, A Forum, A Fuhrer ….
    Reply With Quote Reply With Quote
  7. 04-02-2018, 05:44 PM #27
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,458
    Rep Power
    10
    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
    A Folk, A Forum, A Fuhrer ….
    Reply With Quote Reply With Quote
  8. 04-02-2018, 05:47 PM #28
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,458
    Rep Power
    10
    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
    A Folk, A Forum, A Fuhrer ….
    Reply With Quote Reply With Quote
  9. 04-02-2018, 05:55 PM #29
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,458
    Rep Power
    10

    Typical Updated Data File, "Raghu.xlsx" after first consolidation

    Typical Updated Data File, "Raghu.xlsx" after first consolidation,
    with the column L updated appropriately with the consolidation date



    Using Excel 2007 32 bit
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    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
    		 02.Apr.2018 Raghu
    3
    5
    		 ABC05
    $ 7.22
    62
    $ 447.64
    		02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    		 02.Apr.2018 Raghu
    4
    9
    		 ABC09
    $ 741.99
    101
    $ 74,940.99
    		02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    		 02.Apr.2018 Raghu
    5
    13
    		 ABC13
    $ 8.51
    12
    $ 102.12
    		02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    		 02.Apr.2018 Raghu
    6
    17
    		 ABC17
    $ 11.99
    1
    $ 11.99
    		02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    		 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
    14
    Worksheet: Tabelle1
    A Folk, A Forum, A Fuhrer ….
    Reply With Quote Reply With Quote
  10. 04-02-2018, 06:15 PM #30
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,458
    Rep Power
    10
    “zMasterAfter1stConsolidationNewData.xlsm” : https://app.box.com/s/ascky2qg47dzl85b4y7l8sy5qmr3goby




    Using Excel 2007 32 bit
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    19
    18
    		 ABC18
    $ 741.99
    101
    $ 74,940.99
    		02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    20
    19
    		 ABC19
    $ 55.00
    22
    $ 1,210.00
    		02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    21
    20
    		 ABC20
    $ 13.66
    7
    $ 95.62
    		02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    22
    21
    		 ABC21
    $ 12.99
    5
    $ 64.95
    		02.Apr.2018 Raghu
    23
    22
    		 ABC22
    $ 8.51
    12
    $ 102.12
    		02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    24
    23
    		 ABC23
    $ 7.22
    62
    $ 447.64
    		02.Apr.2018 Greg
    25
    24
    		 ABC24
    $ 3.99
    35
    $ 139.65
    		02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    26
    25
    		 ABC25
    $ 333.45
    99
    $ 33,011.55
    		02.Apr.2018 Raghu
    27
    26
    		 ABC26
    $ 11.99
    1
    $ 11.99
    		02.Apr.2018 John
    28
    27
    		 ABC27
    $ 741.99
    101
    $ 74,940.99
    		02.Apr.2018 Greg
    29
    28
    		 ABC28
    $ 55.00
    22
    $ 1,210.00
    		02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    30
    29
    		 ABC29
    $ 13.66
    7
    $ 95.62
    		02.Apr.2018 Raghu
    31
    30
    		 ABC30
    $ 12.99
    5
    $ 64.95
    		02.Apr.2018 John
    32
    31
    		 ABC31
    $ 8.51
    12
    $ 102.12
    		02.Apr.2018 Greg
    33
    32
    		 ABC32
    $ 7.22
    62
    $ 447.64
    		02.Apr.2018 Margaret
    34
    33
    		 ABC33
    $ 3.99
    35
    $ 139.65
    		02.Apr.2018 Raghu
    35
    34
    		 ABC34
    $ 333.45
    99
    $ 33,011.55
    		02.Apr.2018 John
    36
    35
    		 ABC35
    $ 11.99
    1
    $ 11.99
    		02.Apr.2018 Greg
    37
    36
    		 ABC36
    $ 741.99
    101
    $ 74,940.99
    		02.Apr.2018 Margaret
    38
    37
    		 ABC37
    $ 55.00
    22
    $ 1,210.00
    		02.Apr.2018 Raghu
    39
    38
    		 ABC38
    $ 13.66
    7
    $ 95.62
    		02.Apr.2018 John
    40
    39
    		 ABC39
    $ 12.99
    5
    $ 64.95
    		02.Apr.2018 Greg
    41
    40
    		 ABC40
    $ 8.51
    12
    $ 102.12
    		02.Apr.2018 Margaret
    42
    41
    		 ABC41
    $ 7.22
    62
    $ 447.64
    		02.Apr.2018 Raghu
    43
    42
    		 ABC42
    $ 3.99
    35
    $ 139.65
    		02.Apr.2018 John
    44
    43
    		 ABC43
    $ 333.45
    99
    $ 33,011.55
    		02.Apr.2018 Greg
    45
    44
    		 ABC44
    $ 11.99
    1
    $ 11.99
    		02.Apr.2018 Margaret
    46
    45
    		 ABC45
    $ 741.99
    101
    $ 74,940.99
    		02.Apr.2018 Raghu
    47
    46
    		 ABC46
    $ 8.51
    12
    $ 102.12
    		 John
    48
    47
    		 ABC47
    $ 7.22
    62
    $ 447.64
    		 Greg
    49
    48
    		 ABC48
    $ 3.99
    35
    $ 139.65
    		 Margaret
    50
    49
    		 ABC49
    $ 333.45
    99
    $ 33,011.55
    		 Raghu
    51
    50
    		 ABC50
    $ 11.99
    1
    $ 11.99
    		 Raghu
    52
    Worksheet: OriginalData
    A Folk, A Forum, A Fuhrer ….
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Notes tests, text files, manipulation of text files in Excel and with Excel VBA CSV stuff
    By DocAElstein in forum Test Area
    Replies: 114
    Last Post: 03-04-2024, 02:39 PM
  2. Word Tests. Useful older stuff. Older versions. Chris stuff etc
    By DocAElstein in forum Test Area
    Replies: 42
    Last Post: 05-29-2023, 01:19 PM
  3. USER FORM ISSUES: Clear data from various ranges using checkboxes and other issues.
    By MrBlackd in forum Excel Help
    Replies: 11
    Last Post: 10-13-2013, 10:53 PM
  4. Opening Last Working Day's File And Copying And Pasting Into Different File
    By Bendrews in forum Excel Help
    Replies: 7
    Last Post: 08-28-2013, 12:57 AM
  5. Declaring API Functions In 64 Bit
    By marreco in forum Excel Help
    Replies: 2
    Last Post: 02-11-2013, 03:18 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules