Page 2 of 55 FirstFirst 12341252 ... LastLast
Results 11 to 20 of 541

Thread: Appendix Thread. 3 *

  1. #11
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10

    Results for RaghavendraPrabhu

    Test


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwviLabd7r_3KpP6wh4AaABAg.9h5lFRmix1R9h78GftO_ iE
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9h77HSGDH 4A
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9h76fafzc EJ
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9h759YIjl aG
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9h74pjGcb Eq
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgzJJUDVv2Mb6YGkPYh4AaABAg.9h5uPRbWIZl9h7165DZd jg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA





    https://www.youtube.com/watch?v=vXyMScSbhk4
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgynOSp1dleo-Z8L_QN4AaABAg.9jJLDC1Z6L-9k68CuL4aTY
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgwV5N_ulFXYMNbyQG54AaABAg.9itCkoVN4w79itOVYVvE wQ
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgyOh-eR43LvlIJLG5p4AaABAg.9isnKJoRfbL9itPC-4uckb
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugy1B1aQnHq2WbbucmR4AaABAg.9isY3Ezhx4j9itQLuif2 6T
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgxxajSt03TX1wxh3IJ4AaABAg.9irSL7x4Moh9itTRqL7d Qh
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg.9irLgSdeU3r9itU7zdnW Hw
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgwJAAPbp8dhkW2X1Uh4AaABAg.9iraombnLDb9itV80HDp Xc
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgzIzQ6MQ5kTpuLbIuB4AaABAg.9is0FSoF2Wi9itWKEvGS Sq



    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwviLabd7r_3KpP6wh4AaABAg.9h5lFRmix1R9h78GftO_ iE
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9h77HSGDH 4A
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9h76fafzc EJ
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9h759YIjl aG
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9h74pjGcb Eq
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgzJJUDVv2Mb6YGkPYh4AaABAg.9h5uPRbWIZl9h7165DZd jg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    A Folk, A Forum, A Fuhrer ….

  2. #12
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10

    Final Results for Code 2b) for Raghavendra

    Final Results for this Thread Post
    http://www.excelfox.com/forum/showth...0575#post10575

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxzpgHWTLGj0C3q3gx4AaABAg.9gxsUMU53al9k5c8W6QG E8
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg.9gxDYq2iiZ89h4ISxLD1 7d
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg.9gxDYq2iiZ89h4LdsDET im
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg.9gxDYq2iiZ89h32czjty R_
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxzpgHWTLGj0C3q3gx4AaABAg
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugw_smEwvNffCPr_nrB4AaABAg.9gvyL53lI1l9gxwd_9-V6z
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugy7vmiHsQ0oUt2QCPZ4AaABAg.9gvoy4OW6lU9gxwxC5-rL9
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgzuX3uYmqJRtsZIbqF4AaABAg.9gth61YhXKB9gxxCMdRL A0
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxcPC64RQGmXwO5rft4AaABAg.9gtQLXaeg0e9gxxNuc5C CM
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwCY8vOs1DFHgYSJwF4AaABAg.9godrFcyWYw9gxy1odpi Rj
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgyL5nh_j8w70-YBoUt4AaABAg.9goMcRjwjtc9gxyslvuZKx
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwwWRgmRZNqJKptHR14AaABAg.9go-DbayTZa9gxzPbefHXf
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwF3wECwc8tVoRmz6B4AaABAg.9go-5xLQM8P9gxzmB7nkVQ
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgyRDmGTHnMdT7dl_qx4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    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=f7xZivqLZxc&lc=UgwhVTFaD469mW9wO194AaABAg.9gJzxwFcnPU9gORqKw5t W_
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugyb8nmKKoXvcdM58gV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwvvXcl1oa79xS7BAV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgxvIFArksPprylHXYZ4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxUbeYSvsBH2Gianox4AaABAg.9VYH-07VTyW9gJV5fDAZNe
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxLtKj969oiIu7zNb94AaABAg
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgyhQ73u0C3V4bEPhYB4AaABAg
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgzIElpI5OFExnUyrk14AaABAg.9fsvd9zwZii9gMUka-NbIZ
    https://www.youtube.com/watch?v=jdPeMPT98QU
    https://www.youtube.com/watch?v=QdwDnUz96W0&lc=Ugx3syV3Bw6bxddVyBx4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    A Folk, A Forum, A Fuhrer ….

  3. #13

  4. #14
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10

    Search for text in txt File using VBA, display rows where text found

    Code in support of these Threads:
    [size=1] http://www.excelfox.com/forum/showth...0582#post10582

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxzpgHWTLGj0C3q3gx4AaABAg.9gxsUMU53al9k5c8W6QG E8
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg.9gxDYq2iiZ89h4ISxLD1 7d
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg.9gxDYq2iiZ89h4LdsDET im
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg.9gxDYq2iiZ89h32czjty R_
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxzpgHWTLGj0C3q3gx4AaABAg
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugw_smEwvNffCPr_nrB4AaABAg.9gvyL53lI1l9gxwd_9-V6z
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugy7vmiHsQ0oUt2QCPZ4AaABAg.9gvoy4OW6lU9gxwxC5-rL9
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgzuX3uYmqJRtsZIbqF4AaABAg.9gth61YhXKB9gxxCMdRL A0
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxcPC64RQGmXwO5rft4AaABAg.9gtQLXaeg0e9gxxNuc5C CM
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwCY8vOs1DFHgYSJwF4AaABAg.9godrFcyWYw9gxy1odpi Rj
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgyL5nh_j8w70-YBoUt4AaABAg.9goMcRjwjtc9gxyslvuZKx
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwwWRgmRZNqJKptHR14AaABAg.9go-DbayTZa9gxzPbefHXf
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwF3wECwc8tVoRmz6B4AaABAg.9go-5xLQM8P9gxzmB7nkVQ
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgyRDmGTHnMdT7dl_qx4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    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=f7xZivqLZxc&lc=UgwhVTFaD469mW9wO194AaABAg.9gJzxwFcnPU9gORqKw5t W_
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugyb8nmKKoXvcdM58gV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwvvXcl1oa79xS7BAV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgxvIFArksPprylHXYZ4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

  5. #15
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    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
    A Folk, A Forum, A Fuhrer ….

  6. #16
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10

    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.

    Attached Images Attached Images
    A Folk, A Forum, A Fuhrer ….

  7. #17
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    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 ….

  8. #18
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    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 ….

  9. #19
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    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 ….

  10. #20
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    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 ….

Similar Threads

  1. Replies: 185
    Last Post: 05-22-2024, 10:02 PM
  2. Replies: 603
    Last Post: 05-20-2024, 03:31 PM
  3. Replies: 293
    Last Post: 09-24-2020, 01:53 AM
  4. Appendix Thread. Diet Protokol Coding Adaptions
    By DocAElstein in forum Test Area
    Replies: 6
    Last Post: 09-05-2019, 10:45 AM

Posting Permissions

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